I uploaded my site to godaddy and I keep getting this when I sign into my site:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces,
error: 26 - Error Locating Server/Instance Specified)
I have seen this in a previous post but I am not sure how this applies to my site, here is my connection string
I have godaddy hosting also and my connection string looks similar but unless you renamed the database I think that could be the problem, take a look at mine. If I remember right, I wasn't able to rename the db. Also try removing spaces between the semi
colon and the next item in the string.
Ok I see. I didn't change the name of my DB but how do I get the connection string from godaddy? if I call will they give it to me. Probably a dumb question but that seems to be my prob. I was searching around the hosting part of my account and I cant
really see how it get it. how did you link it to their server?
After I logged in, on the left navigation there is a link named "Hosting", click it. On the next page it will show your hosting accounts, click on the account in Manage Account under the Control Panel header. This will open another window, in which you
click on the Databases in the Accordion control then click on SQL Server. There it will show your SQL Server version and name. If you click on the pencil it will display all your info with the exception of your password.
Good luck, hope this helps
Remember to mark as answer if this post answered or solved your problem.
Marked as answer by rogriall79 on Apr 30, 2009 03:54 AM
OK I have one more question. I actually have the connection to my DB but it only shows my ASP Tables and not my Products Tables. I was wondering if you know whtI might be doing wrong. I actually went through and got rid of all my login and membership
pages and tables from my website to see what is wrong. I am now thinking I might be using the wrong connection string. I used the string
OLE DB, OleDbConnection (.NET):
For my DB but only my ASP tables are showing. Do you think it might be something else? Should I use a different Connection string? I am not sure why I can only see my ASP tables and not my Product Tables. This is even after I deleted all login stuff
from my site.
It is starting to get to me a bit.....I really hope you can help, I am not sure why after connecting my DB only select tables are able to be used.
rogriall79
Member
13 Points
18 Posts
problems connecting to SQL Server 2005
Apr 24, 2009 10:43 PM|LINK
I uploaded my site to godaddy and I keep getting this when I sign into my site:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I have seen this in a previous post but I am not sure how this applies to my site, here is my connection string
<connectionStrings>
<clear />
<add name="AspnetdbConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\GNJDB.MDF;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
<add name="GNJDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\GNJDB.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
So do I delete this and replace it with this:
connectionStrings>
<add name="Personal" connectionString=" Server=p3swhsql-v07.shr.phx3.secureserver.net; Database=Personal; User ID=yourusername; Password=yourpassword; Trusted_Connection=False" providerName="System.Data.SqlClient"/><remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString=" Server=p3swhsql-v07.shr.phx3.secureserver.net; Database=ASPNETDB; User ID=yourusername; Password=yourpassword; Trusted_Connection=False" providerName="System.Data.SqlClient"/></
connectionStrings>I am new to this so I didn't even know I had to change anything in my web.config file and godaddy didn't say anything either.
Thanks to anyone who can help me become less confused
rogriall79
b471code3
Star
13877 Points
2598 Posts
Re: problems connecting to SQL Server 2005
Apr 25, 2009 02:26 AM|LINK
I have godaddy hosting also and my connection string looks similar but unless you renamed the database I think that could be the problem, take a look at mine. If I remember right, I wasn't able to rename the db. Also try removing spaces between the semi colon and the next item in the string.
<
add name="SiteSqlServer" connectionString="Server=whsql-v24.prod.mesa1.secureserver.net;Database=fro0809907092288;uid=myuid;pwd=mypwd" providerName="System.Data.SqlClient" />rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
Apr 26, 2009 07:14 PM|LINK
Ok I see. I didn't change the name of my DB but how do I get the connection string from godaddy? if I call will they give it to me. Probably a dumb question but that seems to be my prob. I was searching around the hosting part of my account and I cant really see how it get it. how did you link it to their server?
b471code3
Star
13877 Points
2598 Posts
Re: problems connecting to SQL Server 2005
Apr 26, 2009 11:58 PM|LINK
After I logged in, on the left navigation there is a link named "Hosting", click it. On the next page it will show your hosting accounts, click on the account in Manage Account under the Control Panel header. This will open another window, in which you click on the Databases in the Accordion control then click on SQL Server. There it will show your SQL Server version and name. If you click on the pencil it will display all your info with the exception of your password.
Good luck, hope this helps
rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
Apr 30, 2009 03:55 AM|LINK
Thanks that helped out a lot. It works great now....
rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
Apr 30, 2009 10:09 PM|LINK
OK I have one more question. I actually have the connection to my DB but it only shows my ASP Tables and not my Products Tables. I was wondering if you know whtI might be doing wrong. I actually went through and got rid of all my login and membership pages and tables from my website to see what is wrong. I am now thinking I might be using the wrong connection string. I used the string
For my DB but only my ASP tables are showing. Do you think it might be something else? Should I use a different Connection string? I am not sure why I can only see my ASP tables and not my Product Tables. This is even after I deleted all login stuff from my site.
It is starting to get to me a bit.....I really hope you can help, I am not sure why after connecting my DB only select tables are able to be used.
Thanks RIch
navigation
b471code3
Star
13877 Points
2598 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 12:38 AM|LINK
Any particular reason you are not using just a regular SQL client provider vs your OLE DB provider?
rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 12:53 AM|LINK
Actually I don't know the difference but I will use this one instead and see how it works:
Not sure what the difference is, I am still reading up on DB and programing so if this is the problem then I will have to look at it more.
Is this what you meant by the regular SQL Client Provider?
rogriall79
Member
13 Points
18 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 01:50 AM|LINK
These r the one i am given......which do u recommend:
-
SqlConnection (.NET):
I am currently using the middle one.b471code3
Star
13877 Points
2598 Posts
Re: problems connecting to SQL Server 2005
May 01, 2009 02:08 AM|LINK
Use the last one.