connection strings

I am trying to develop a web site. I have a local ms sql database on my machine.

I am trying to connect to a ms Sql database on a goDaddy server from the application.

I am trying to understand the connection string and its total properties.

here is what I think should be in my web.config file

<

add name="Personal" connectionString="Server=whsql-v12.prod.mesa1.secureserver.net;

Database=DB_XX10;

User ID=myID;

Password=myypassword;

Trusted_Connection=False" providerName="System.Data.SqlClient"

/>

<remove name="LocalSqlServer"/>

can someone please tell me where I am going wrong, Thanks for your help....

If you search these forums for "GoDaddy" you will find that a lot of people have had problems with them. One being, that Go Daddy does not allow remote SQL Server connections.|||

Do you think it might be possible that somene would share their web.config that would overcome the problem?

Am I asking too much to think that I could develop my site locally and then have some reasonable way of uploading the web site AND update the database on the GODaddy ms sql server with the new data etc.

I am really looking for an overview of the process.

Thanks for your response......

|||You can NOT use a GoDaddy SQL Server from any server except their own, that is how they have things configured. It isn't about the Connection String.|||

So that means I can not access The GODADDY server from my local development enviroment?

SO to set up a development enviroment I would have to update the database directly as well as the web site it self. Is there a overview of such an enviroment available on the net AnyWhere?

Thanks for your quick response

|||

krisfr:

So that means I can not access The GODADDY server from my local development enviroment?

Pretty much. Can't do it. As for your other question, I am not sure. Google can help though.

|||Can I set up the web.config to look for the database locally first, and if it can not find the database then look for the GoDaddy datadase?|||Not really, no. What you can do is setup two connection strings, one for local and another for GoDaddy, and switch them out.

Connection String Problem

I am working on a new website where the ISP (GoDaddy) has plans that include
a sql server (one db). I setup the db, built and partially populated some
tables and, from an aspx page on that account, I figured out the connection
string - works pretty well (I sure miss EM!). Now, I want to create a
windows application (desktop) to manage some aspects of that database but
the server name that works from the aspx page does not work from a windows
application. The sql server "address" is something like"
xxsql01.prod.xxxx1.secureserver.net
(Not sure if that is a name limited to the account so I "x" out parts of
it?) and there is a DB name which I use as the Initial Catalog.
Has anyone dealt with this type of server before? Any hints on how to
address it externally? I tried prefixing that address with the domain name
of the ISP account but that did not help
Appreciate any suggestions.
WayneUsing Enterprise Manager, I can register SQL Server hosted at my ISP via IP
address. Just try specifying the IP for the server name.
"Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
news:eW6auhuDFHA.2220@.TK2MSFTNGP09.phx.gbl...
> I am working on a new website where the ISP (GoDaddy) has plans that
include
> a sql server (one db). I setup the db, built and partially populated some
> tables and, from an aspx page on that account, I figured out the
connection
> string - works pretty well (I sure miss EM!). Now, I want to create a
> windows application (desktop) to manage some aspects of that database but
> the server name that works from the aspx page does not work from a windows
> application. The sql server "address" is something like"
> xxsql01.prod.xxxx1.secureserver.net
> (Not sure if that is a name limited to the account so I "x" out parts of
> it?) and there is a DB name which I use as the Initial Catalog.
>
> Has anyone dealt with this type of server before? Any hints on how to
> address it externally? I tried prefixing that address with the domain name
> of the ISP account but that did not help
>
> Appreciate any suggestions.
>
> Wayne
>|||Ask your provider if the SQL-Server is directly accessible from the internet
and not blocked by a firewall. Many (most ?) ISP are now blocking the port
1433 to *protect* the sql-servers from outside attacks.
Even if the SQL-Server is accessible from the outside (Internet), if there
is a proxy then the connection string might be different then the one used
for ASP.NET.
S. L.
"Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
news:eW6auhuDFHA.2220@.TK2MSFTNGP09.phx.gbl...
>I am working on a new website where the ISP (GoDaddy) has plans that
>include
> a sql server (one db). I setup the db, built and partially populated some
> tables and, from an aspx page on that account, I figured out the
> connection
> string - works pretty well (I sure miss EM!). Now, I want to create a
> windows application (desktop) to manage some aspects of that database but
> the server name that works from the aspx page does not work from a windows
> application. The sql server "address" is something like"
> xxsql01.prod.xxxx1.secureserver.net
> (Not sure if that is a name limited to the account so I "x" out parts of
> it?) and there is a DB name which I use as the Initial Catalog.
>
> Has anyone dealt with this type of server before? Any hints on how to
> address it externally? I tried prefixing that address with the domain name
> of the ISP account but that did not help
>
> Appreciate any suggestions.
>
> Wayne
>|||Thanks guys. I'll pursue those suggestions.
Wayne
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OqUzD9uDFHA.148@.TK2MSFTNGP14.phx.gbl...
> Ask your provider if the SQL-Server is directly accessible from the
internet
> and not blocked by a firewall. Many (most ?) ISP are now blocking the
port
> 1433 to *protect* the sql-servers from outside attacks.
> Even if the SQL-Server is accessible from the outside (Internet), if there
> is a proxy then the connection string might be different then the one used
> for ASP.NET.
> S. L.
> "Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
> news:eW6auhuDFHA.2220@.TK2MSFTNGP09.phx.gbl...
some
but
windows
name
>

Connection string for MS SQLServer 2000

For nearly 6 wks I have been trying to workout with GoDaddy.com a connection string that will connect to the SQL Server 2000 from my ASP.Net web application. In my programming, I have placed the connection string in the web.config file and then call it from there within code behind using the SQLConnection object.
My web.config entry has the following form:

<appSettings>

<addkey="Conn"value="server=GoDaddyserver;integrated security=SSPI;database=databaseonGoDaddyserver;" />

</appSettings>
I have also written the key supplying the UID and pwd. Nothing works and their support is of no help.
Has anyone else had this difficulty either in general or with GoDaddy in particular?

Try the connectionstrings athttp://www.connectiosntrings.com. You would be using SQL Server authentication (standard security), notWindows authentication (trusted connection), so you will be specifyinga user name and password in the connection string.
|||Thanks, Terry. I've tried the connection string with the username and password in place of the trusted security--still no connection. The link you supplied does not seem to work.|||Sorry, I should have copied and posted it instead of typing it in:-) Hopefully you figured out my typo by now. It shouldhave beenhttp://www.connectionstrings.com.
|||Terri, I apologize for misspelling your name in my last reply. I wondered if that was the URL you meant. That's a great site and I have used it several times. Is it acceptable to ask if others would have a recommendation for a good ASP.Net hosting company? I just can't seem to work things out with GoDaddy.
Vern|||The best place for that hosting question is here:http://forums.asp.net/92/ShowForum.aspx. Try searching through theforum for suggestions, or post your own plea for help (realizing thatpeople representing ISPs hang out there and will be vocal that theirservice is the best).
With an IP address, the connection string should probably look like this:
"Data Source=127.0.0.1,1433;Network Library=DBMSSOCN;Initial Catalog=databaseonGoDaddyserver;User Id=yourSuppliedUserID;Password=yourSuppliedPassword;"

Without an IP address, the connection string should probably look like this:
"Data Source=SQL99.GoDaddy.com;Initial Catalog=databaseonGoDaddyserver;User Id=yourSuppliedUserID;Password=yourSuppliedPassword;"
What is the exact error you are receiving when you use the connection string with a user ID and password?

|||

Check your SQL Server user settings under Enterprise Manager and make sure that the username has permit rights to the database. Then if you want to be secure you will have to go to each table's security settings in that database and give the username select rights to the table. If you are using stored procs you will need to go to each proc and give the user name execute rights.
Also it would help if you would list us a code example of how you are using the connection string.

|||Terri, thanks for the hosting resource; here is the error:
Exception Details:System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 VanDyke.StartUp.GetBio() in C:\VanDyke\default.aspx.vb:79 VanDyke.StartUp.Page_Load(Object sender, EventArgs e) in C:\VanDyke\default.aspx.vb:67 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750

|||Part of my difficulty is that I have no management tool remotely similar to Enterprise Manager at GoDaddy, so I'm unsure of how they have users and privelges setup. I understand completely what you're recommending, however.
Code sample:

Dim connAsNew SqlConnection(ConfigurationSettings.AppSettings("Conn"))

conn.Open()

|||Can't you hook up your local Enterprise Manager to your remote GoDaddydatabase? I've been able to do this with the server I use asCrystalTech?
Otherwise, there are just so many possibilities. I am at a losswithotu seeing it for myself and working with it. It sounds likeyou need to give the user in your connection string permission toaccess your database. Without Enterprise Manager, I am not surehow to go about that. Doesn't GoDaddy give you *some* sort ofmanagement tool?
|||

The only other thing I can suggest is to make sure that your not having a DNS issue. Instead of using GoDaddy for the server name try using the ip address and see if that works.

|||Terri, GoDaddy management console only permits access to tables,veiws, and stored procedures; no way to get to users/permissions.
Using Enterprise Manager doesn't give me access as best I canfigure. I added a SQL Server Group which I named GoDaddy. Then tried to add a server registration, using the server address thatGoDaddy provides (whsql-v**.****.mesa*.secure***.net). Ielected SQL Server authentication and entered the user name andpassword I have that gives me access to the GoDaddy managementconsole--don't have a userID/pwd for the database server as best I cantell although I don't know that the credentials for the managementconsole aren't also intended to give database access. Anyway, Icannot establish a connection doing it as described.
|||It sounds like it is about time to contact the company you are hosting the Database with and ask them how your suppose to connect to the DB Server. Sounds like they don't even have an account on the box setup for you to use via ASP.NET. If you are paying for a service you should have access to it. I recommendwww.brinkster.com if this company can not statisfy your needs I would close my account and go with another company.|||

OldStretch wrote:

GoDaddy management console only permits access to tables,veiws, and stored procedures; no way to get to users/permissions.

Wow, that is the exact opposite of how Crystal Tech works.

OldStretch wrote:

don't have a userID/pwd for the database server as best I cantell although I don't know that the credentials for the managementconsole aren't also intended to give database access. Anyway, Icannot establish a connection doing it as described.

You didn't post an error message, but that is telling me the user nameand password are wrong. That is the crux of the problem. Ihighly doubt the management console user name and password would be thesame as that needed to access your database.
Don't they have support forums/documentation.anything? And you've been struggling with this for 6 weeks?

|||Does your SQL Server have an instance name? The conn string my need to be SERVERNAME/INSTANCENAME.