Hi All,

I am writing one ASP application with SQL Server as database. When I am t

rying

to login in to the server, I am getting an error :Login failed for user '

\'. 



Please let me know what I have to do to get rid of it.



Thanks



G De 



 

I would make sure the webserver is a local machine user/administrator to the

machine running SQL server.

----- Original Message -----

From: "Gautam De" <gautamde_tech@u...>

To: "ASP Databases" <asp_databases@p...>

Cc: <gautamde_tech@u...>

Sent: Monday, August 14, 2000 12:32 PM

Subject: [asp_databases] SQL Server connection problem







Hi All,

I am writing one ASP application with SQL Server as database. When I am

trying

to login in to the server, I am getting an error :Login failed for user '\'.

Please let me know what I have to do to get rid of it.



Thanks



G De





---

You are currently subscribed to asp_databases

I believe that the problem lies in your connection string.  I had the exact 

same problem and re-worked my connection properties and it now works.



My problem was using "UserID=someid","pwd=somepass"



When I removed the 'UserID' and 'pwd', the connection worked and my boss 

was again happy.  Try just putting your id and pass in quotes like:

  "someid","somepass"



If anyone out there knows the proper syntax for a SQL database it would be 

helpful to post it(as I tried UserID, UID, PWD, pwd, Pwd, password, and 

none worked!).



Hope this helps

http://www.able-consulting.com/ADO_Conn.htm



Cheers

Ken



> If anyone out there knows the proper syntax for a SQL database it would be

> helpful to post it(as I tried UserID, UID, PWD, pwd, Pwd, password, and

> none worked!).

You may not be using the correct User Name and PassWord

It will be better if u can test using the following method



' Create the connection object

   Set cnNorthwind = CreateObject("ADODB.Connection")

   ' Set the connection string

   cnNorthwind.ConnectionString = "Provider=SQLOLEDB.1;" & _

      "User ID=sa;Initial Catalog=Northwind;Data Source=TESTPC"

   ' Open the connection

   cnNorthwind.Open



-----Original Message-----

From:	Gautam De [SMTP:gautamde_tech@u...]

Sent:	Tuesday, August 15, 2000 1:02 AM

To:	ASP Databases

Cc:	gautamde_tech@u...

Subject:	[asp_databases] SQL Server connection problem

Importance:	High



  

Hi All,

I am writing one ASP application with SQL Server as database. When I am trying

to login in to the server, I am getting an error :Login failed for user '\'. 

Please let me know what I have to do to get rid of it.



Thanks



G De 

 



---

You are currently subscribed to asp_databases