Creating Logins For Web Application

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Creating Logins For Web Application

Author

Topic

marcopolo8
Starting Member

1 Post

Posted - 2011-01-31 : 12:52:38

I've been given access to a client's SQL Server (via VPN) in order to create a login for a web application. When using Management Studio, I go thru what seems to be pretty straighfoward a process to create a login for my .asp pages to connect to the database. I've verified the IP addy of the sql server, the login and the login password, but the sql server isn't allowing my web app to connect? The client set me up to access Management Studio using Windows Authentication. My web app is attempting to connect using SQL Server Authentication.

I get the following message when creating a simple .asp page, create a connection string and object and attempt to simply open and close the connection:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
/beta/test.asp, line 5

When I ping the IP of the sql server (when I'm connected via VPN), I get a response, so therefore I think it may be something I'm doing wrong when setting up the login. The web server and database server are all running internally on the client's network

Any help would be appreciated or if an online step-by-step tutorial is available that someone knows about, I'd really be grateful for the URL to such.

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-02-02 : 00:45:30

try to use sql server authentication or pass credintial through web config