C#/asp.net application runs fine on localhost (intranet), but not on server (Internet) The 2019 Stack Overflow Developer Survey Results Are InSQL Server 2008 login problem with ASP.NET application: Failed to open the explicitly specified databaseASP.NET web services and SQL Server ExpressWhat is easiest no fail way to publish asp.net app?Problem publishing ASP.net web application on University serverWindows 7 IIS 7.5 ASPX Pages Hang IIS in Application migrated from IIS6global.asax works on local computer but not after i publish to serverasp.net iis server red asterisk page validationHow can I view the SQL Server database created by an ASP.NET MVC web application?ASP.NET 2.0 has not been registered on the web server IIS10 Windows 10SMTP working from localhost but not on shared hostning server
Loose spokes after only a few rides
Is a "Democratic" Oligarchy-Style System Possible?
Does a dangling wire really electrocute me if I'm standing in water?
How to notate time signature switching consistently every measure
Shouldn't "much" here be used instead of "more"?
What is the meaning of the verb "bear" in this context?
Why was M87 targetted for the Event Horizon Telescope instead of Sagittarius A*?
For what reasons would an animal species NOT cross a *horizontal* land bridge?
Is bread bad for ducks?
Multiply Two Integer Polynomials
Is "plugging out" electronic devices an American expression?
If a Druid sees an animal’s corpse, can they wild shape into that animal?
Earliest use of the term "Galois extension"?
Why can Shazam fly?
Is there any way to tell whether the shot is going to hit you or not?
Do these rules for Critical Successes and Critical Failures seem Fair?
What does "fetching by region is not available for SAM files" means?
Can we generate random numbers using irrational numbers like π and e?
What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?
Is this app Icon Browser Safe/Legit?
Did Section 31 appear in Star Trek: The Next Generation?
What is the accessibility of a package's `Private` context variables?
Where to refill my bottle in India?
Who coined the term "madman theory"?
C#/asp.net application runs fine on localhost (intranet), but not on server (Internet)
The 2019 Stack Overflow Developer Survey Results Are InSQL Server 2008 login problem with ASP.NET application: Failed to open the explicitly specified databaseASP.NET web services and SQL Server ExpressWhat is easiest no fail way to publish asp.net app?Problem publishing ASP.net web application on University serverWindows 7 IIS 7.5 ASPX Pages Hang IIS in Application migrated from IIS6global.asax works on local computer but not after i publish to serverasp.net iis server red asterisk page validationHow can I view the SQL Server database created by an ASP.NET MVC web application?ASP.NET 2.0 has not been registered on the web server IIS10 Windows 10SMTP working from localhost but not on shared hostning server
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I'm a total n00b when it comes to SQL Server admin stuff, so sorry if this is basic. I've designed a website in C#/asp.net with a SQL Server backend on my local machine. Runs perfectly when I open the site through VS2010 and run it. However, when I publish it to IIS and try to run the site, the ASPX works fine but it can't connect to the data. The dropdowns are empty, and anything that deals with data (including logins) doesn't connect to the tables.
I'm assuming this has something to do with permissions? Can anyone help me?
I'm using SQL Server 2008 R2 and Visual Studio 2010, both on a WinXP machine (yeah, I know WinXP isn't built for this, but I just want to test this out before I upload it to a server I have to pay for).
iis windows-xp asp.net sql-server-2008-r2 visual-studio-2010
asked Jan 6 '16 at 4:49
Johnny BonesJohnny Bones
10516
add a comment |
I'm a total n00b when it comes to SQL Server admin stuff, so sorry if this is basic. I've designed a website in C#/asp.net with a SQL Server backend on my local machine. Runs perfectly when I open the site through VS2010 and run it. However, when I publish it to IIS and try to run the site, the ASPX works fine but it can't connect to the data. The dropdowns are empty, and anything that deals with data (including logins) doesn't connect to the tables.
I'm assuming this has something to do with permissions? Can anyone help me?
I'm using SQL Server 2008 R2 and Visual Studio 2010, both on a WinXP machine (yeah, I know WinXP isn't built for this, but I just want to test this out before I upload it to a server I have to pay for).
iis windows-xp asp.net sql-server-2008-r2 visual-studio-2010
asked Jan 6 '16 at 4:49
Johnny BonesJohnny Bones
10516
add a comment |
I'm a total n00b when it comes to SQL Server admin stuff, so sorry if this is basic. I've designed a website in C#/asp.net with a SQL Server backend on my local machine. Runs perfectly when I open the site through VS2010 and run it. However, when I publish it to IIS and try to run the site, the ASPX works fine but it can't connect to the data. The dropdowns are empty, and anything that deals with data (including logins) doesn't connect to the tables.
I'm assuming this has something to do with permissions? Can anyone help me?
I'm using SQL Server 2008 R2 and Visual Studio 2010, both on a WinXP machine (yeah, I know WinXP isn't built for this, but I just want to test this out before I upload it to a server I have to pay for).
iis windows-xp asp.net sql-server-2008-r2 visual-studio-2010
asked Jan 6 '16 at 4:49
Johnny BonesJohnny Bones
10516
I'm a total n00b when it comes to SQL Server admin stuff, so sorry if this is basic. I've designed a website in C#/asp.net with a SQL Server backend on my local machine. Runs perfectly when I open the site through VS2010 and run it. However, when I publish it to IIS and try to run the site, the ASPX works fine but it can't connect to the data. The dropdowns are empty, and anything that deals with data (including logins) doesn't connect to the tables.
I'm assuming this has something to do with permissions? Can anyone help me?
I'm using SQL Server 2008 R2 and Visual Studio 2010, both on a WinXP machine (yeah, I know WinXP isn't built for this, but I just want to test this out before I upload it to a server I have to pay for).
iis windows-xp asp.net sql-server-2008-r2 visual-studio-2010
iis windows-xp asp.net sql-server-2008-r2 visual-studio-2010
asked Jan 6 '16 at 4:49
Johnny BonesJohnny Bones
10516
asked Jan 6 '16 at 4:49
Johnny BonesJohnny Bones
10516
asked Jan 6 '16 at 4:49
Johnny BonesJohnny Bones
10516
asked Jan 6 '16 at 4:49
Johnny BonesJohnny Bones
10516
asked Jan 6 '16 at 4:49
Johnny BonesJohnny Bones
10516
10516
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Did you check the web.config file to see to which database server is it connecting to. Check if the Database server name is 'localhost'. If it is so, change it to the correct server name. Also, check if the tables have data in them.
Thanks,
San.
answered Jan 6 '16 at 10:57
user2090357user2090357
1
Database server name is not localhost, and the tables have data in them. The dropdowns get populated when I run it from VS, but not when I run it from 192.168.1.1 (which is the internal IP address of my computer). My connection string is: <add name="OLDSiteConn" connectionString="Data Source=old-tymemonarch;Initial Catalog=Monarch;Integrated Security=True" providerName="System.Data.SqlClient"/>
– Johnny Bones
Jan 6 '16 at 11:49
@JohnnyBones Are you getting any error messages from your application, such as the database not being reached? I notice you are using Integrated Security. It could be a mixup with Windows credentials between machines. You could create a SQL user account for that particular database, assign the appropriate permissions and then use that in your connection string.
– Cody Hicks
Jan 7 '16 at 17:14
@CodyHicks - No visible errors, but it's got to be something in the connection since it works fine from within Visual Studio. I'm going to tinker with the connection string. I have no idea how to set up an account on SQL Server, I know just enough to get it up and running.
– Johnny Bones
Jan 7 '16 at 18:19
@JohnnyBones You could check connectionstrings.com/sql-server as a reference. To set up a user in SQL (system user to be used by applications if youd like).. Open SQL Server Management Studio, point to your SQL server instance.. Open the 'security' folder and then the 'Logins' folder. right-click the 'Logins' folder to add a new login. From there, you can add the login, point to the particular database you want the login to have permissions for etc.
– Cody Hicks
Jan 7 '16 at 18:44
1
@CodyHicks - Just getting back to this but you were right. Once I set up a new login, it worked fine. Thanks!
– Johnny Bones
Feb 8 '16 at 20:46
|
show 1 more comment
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f747016%2fc-asp-net-application-runs-fine-on-localhost-intranet-but-not-on-server-int%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Did you check the web.config file to see to which database server is it connecting to. Check if the Database server name is 'localhost'. If it is so, change it to the correct server name. Also, check if the tables have data in them.
Thanks,
San.
answered Jan 6 '16 at 10:57
user2090357user2090357
1
Database server name is not localhost, and the tables have data in them. The dropdowns get populated when I run it from VS, but not when I run it from 192.168.1.1 (which is the internal IP address of my computer). My connection string is: <add name="OLDSiteConn" connectionString="Data Source=old-tymemonarch;Initial Catalog=Monarch;Integrated Security=True" providerName="System.Data.SqlClient"/>
– Johnny Bones
Jan 6 '16 at 11:49
@JohnnyBones Are you getting any error messages from your application, such as the database not being reached? I notice you are using Integrated Security. It could be a mixup with Windows credentials between machines. You could create a SQL user account for that particular database, assign the appropriate permissions and then use that in your connection string.
– Cody Hicks
Jan 7 '16 at 17:14
@CodyHicks - No visible errors, but it's got to be something in the connection since it works fine from within Visual Studio. I'm going to tinker with the connection string. I have no idea how to set up an account on SQL Server, I know just enough to get it up and running.
– Johnny Bones
Jan 7 '16 at 18:19
@JohnnyBones You could check connectionstrings.com/sql-server as a reference. To set up a user in SQL (system user to be used by applications if youd like).. Open SQL Server Management Studio, point to your SQL server instance.. Open the 'security' folder and then the 'Logins' folder. right-click the 'Logins' folder to add a new login. From there, you can add the login, point to the particular database you want the login to have permissions for etc.
– Cody Hicks
Jan 7 '16 at 18:44
1
@CodyHicks - Just getting back to this but you were right. Once I set up a new login, it worked fine. Thanks!
– Johnny Bones
Feb 8 '16 at 20:46
|
show 1 more comment
Did you check the web.config file to see to which database server is it connecting to. Check if the Database server name is 'localhost'. If it is so, change it to the correct server name. Also, check if the tables have data in them.
Thanks,
San.
answered Jan 6 '16 at 10:57
user2090357user2090357
1
Database server name is not localhost, and the tables have data in them. The dropdowns get populated when I run it from VS, but not when I run it from 192.168.1.1 (which is the internal IP address of my computer). My connection string is: <add name="OLDSiteConn" connectionString="Data Source=old-tymemonarch;Initial Catalog=Monarch;Integrated Security=True" providerName="System.Data.SqlClient"/>
– Johnny Bones
Jan 6 '16 at 11:49
@JohnnyBones Are you getting any error messages from your application, such as the database not being reached? I notice you are using Integrated Security. It could be a mixup with Windows credentials between machines. You could create a SQL user account for that particular database, assign the appropriate permissions and then use that in your connection string.
– Cody Hicks
Jan 7 '16 at 17:14
@CodyHicks - No visible errors, but it's got to be something in the connection since it works fine from within Visual Studio. I'm going to tinker with the connection string. I have no idea how to set up an account on SQL Server, I know just enough to get it up and running.
– Johnny Bones
Jan 7 '16 at 18:19
@JohnnyBones You could check connectionstrings.com/sql-server as a reference. To set up a user in SQL (system user to be used by applications if youd like).. Open SQL Server Management Studio, point to your SQL server instance.. Open the 'security' folder and then the 'Logins' folder. right-click the 'Logins' folder to add a new login. From there, you can add the login, point to the particular database you want the login to have permissions for etc.
– Cody Hicks
Jan 7 '16 at 18:44
1
@CodyHicks - Just getting back to this but you were right. Once I set up a new login, it worked fine. Thanks!
– Johnny Bones
Feb 8 '16 at 20:46
|
show 1 more comment
Did you check the web.config file to see to which database server is it connecting to. Check if the Database server name is 'localhost'. If it is so, change it to the correct server name. Also, check if the tables have data in them.
Thanks,
San.
answered Jan 6 '16 at 10:57
user2090357user2090357
1
Did you check the web.config file to see to which database server is it connecting to. Check if the Database server name is 'localhost'. If it is so, change it to the correct server name. Also, check if the tables have data in them.
Thanks,
San.
answered Jan 6 '16 at 10:57
user2090357user2090357
1
answered Jan 6 '16 at 10:57
user2090357user2090357
1
answered Jan 6 '16 at 10:57
user2090357user2090357
1
answered Jan 6 '16 at 10:57
user2090357user2090357
1
1
Database server name is not localhost, and the tables have data in them. The dropdowns get populated when I run it from VS, but not when I run it from 192.168.1.1 (which is the internal IP address of my computer). My connection string is: <add name="OLDSiteConn" connectionString="Data Source=old-tymemonarch;Initial Catalog=Monarch;Integrated Security=True" providerName="System.Data.SqlClient"/>
– Johnny Bones
Jan 6 '16 at 11:49
@JohnnyBones Are you getting any error messages from your application, such as the database not being reached? I notice you are using Integrated Security. It could be a mixup with Windows credentials between machines. You could create a SQL user account for that particular database, assign the appropriate permissions and then use that in your connection string.
– Cody Hicks
Jan 7 '16 at 17:14
@CodyHicks - No visible errors, but it's got to be something in the connection since it works fine from within Visual Studio. I'm going to tinker with the connection string. I have no idea how to set up an account on SQL Server, I know just enough to get it up and running.
– Johnny Bones
Jan 7 '16 at 18:19
@JohnnyBones You could check connectionstrings.com/sql-server as a reference. To set up a user in SQL (system user to be used by applications if youd like).. Open SQL Server Management Studio, point to your SQL server instance.. Open the 'security' folder and then the 'Logins' folder. right-click the 'Logins' folder to add a new login. From there, you can add the login, point to the particular database you want the login to have permissions for etc.
– Cody Hicks
Jan 7 '16 at 18:44
1
@CodyHicks - Just getting back to this but you were right. Once I set up a new login, it worked fine. Thanks!
– Johnny Bones
Feb 8 '16 at 20:46
|
show 1 more comment
Database server name is not localhost, and the tables have data in them. The dropdowns get populated when I run it from VS, but not when I run it from 192.168.1.1 (which is the internal IP address of my computer). My connection string is: <add name="OLDSiteConn" connectionString="Data Source=old-tymemonarch;Initial Catalog=Monarch;Integrated Security=True" providerName="System.Data.SqlClient"/>
– Johnny Bones
Jan 6 '16 at 11:49
@JohnnyBones Are you getting any error messages from your application, such as the database not being reached? I notice you are using Integrated Security. It could be a mixup with Windows credentials between machines. You could create a SQL user account for that particular database, assign the appropriate permissions and then use that in your connection string.
– Cody Hicks
Jan 7 '16 at 17:14
@CodyHicks - No visible errors, but it's got to be something in the connection since it works fine from within Visual Studio. I'm going to tinker with the connection string. I have no idea how to set up an account on SQL Server, I know just enough to get it up and running.
– Johnny Bones
Jan 7 '16 at 18:19
@JohnnyBones You could check connectionstrings.com/sql-server as a reference. To set up a user in SQL (system user to be used by applications if youd like).. Open SQL Server Management Studio, point to your SQL server instance.. Open the 'security' folder and then the 'Logins' folder. right-click the 'Logins' folder to add a new login. From there, you can add the login, point to the particular database you want the login to have permissions for etc.
– Cody Hicks
Jan 7 '16 at 18:44
1
@CodyHicks - Just getting back to this but you were right. Once I set up a new login, it worked fine. Thanks!
– Johnny Bones
Feb 8 '16 at 20:46
Database server name is not localhost, and the tables have data in them. The dropdowns get populated when I run it from VS, but not when I run it from 192.168.1.1 (which is the internal IP address of my computer). My connection string is: <add name="OLDSiteConn" connectionString="Data Source=old-tymemonarch;Initial Catalog=Monarch;Integrated Security=True" providerName="System.Data.SqlClient"/>
– Johnny Bones
Jan 6 '16 at 11:49
Database server name is not localhost, and the tables have data in them. The dropdowns get populated when I run it from VS, but not when I run it from 192.168.1.1 (which is the internal IP address of my computer). My connection string is: <add name="OLDSiteConn" connectionString="Data Source=old-tymemonarch;Initial Catalog=Monarch;Integrated Security=True" providerName="System.Data.SqlClient"/>
– Johnny Bones
Jan 6 '16 at 11:49
@JohnnyBones Are you getting any error messages from your application, such as the database not being reached? I notice you are using Integrated Security. It could be a mixup with Windows credentials between machines. You could create a SQL user account for that particular database, assign the appropriate permissions and then use that in your connection string.
– Cody Hicks
Jan 7 '16 at 17:14
@JohnnyBones Are you getting any error messages from your application, such as the database not being reached? I notice you are using Integrated Security. It could be a mixup with Windows credentials between machines. You could create a SQL user account for that particular database, assign the appropriate permissions and then use that in your connection string.
– Cody Hicks
Jan 7 '16 at 17:14
@CodyHicks - No visible errors, but it's got to be something in the connection since it works fine from within Visual Studio. I'm going to tinker with the connection string. I have no idea how to set up an account on SQL Server, I know just enough to get it up and running.
– Johnny Bones
Jan 7 '16 at 18:19
@CodyHicks - No visible errors, but it's got to be something in the connection since it works fine from within Visual Studio. I'm going to tinker with the connection string. I have no idea how to set up an account on SQL Server, I know just enough to get it up and running.
– Johnny Bones
Jan 7 '16 at 18:19
@JohnnyBones You could check connectionstrings.com/sql-server as a reference. To set up a user in SQL (system user to be used by applications if youd like).. Open SQL Server Management Studio, point to your SQL server instance.. Open the 'security' folder and then the 'Logins' folder. right-click the 'Logins' folder to add a new login. From there, you can add the login, point to the particular database you want the login to have permissions for etc.
– Cody Hicks
Jan 7 '16 at 18:44
@JohnnyBones You could check connectionstrings.com/sql-server as a reference. To set up a user in SQL (system user to be used by applications if youd like).. Open SQL Server Management Studio, point to your SQL server instance.. Open the 'security' folder and then the 'Logins' folder. right-click the 'Logins' folder to add a new login. From there, you can add the login, point to the particular database you want the login to have permissions for etc.
– Cody Hicks
Jan 7 '16 at 18:44
1
1
@CodyHicks - Just getting back to this but you were right. Once I set up a new login, it worked fine. Thanks!
– Johnny Bones
Feb 8 '16 at 20:46
@CodyHicks - Just getting back to this but you were right. Once I set up a new login, it worked fine. Thanks!
– Johnny Bones
Feb 8 '16 at 20:46
|
show 1 more comment
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f747016%2fc-asp-net-application-runs-fine-on-localhost-intranet-but-not-on-server-int%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
