Connecting SQL Server with DW using ASP.NET VB

[Mike1500]

Hello All,

I'm trying to connect SQL Server with DW using ASP.NET VB using several
connection strings and getting different error messages. The connection string
I used and the error message that I received are listed below. Can someone
provide me with the proper connection string to connect to SQL Server using
ASP.NET VB?? Please help. Thanks.

If I use this following connection string

"Persist Security Info=False;
Data Source=[Test_Table];
Initial Catalog=[Test_Table]"

I get this error message

Invaild authorization specification


When I use this connection sting

Persist Security Info=False;
Data Source=[Test_Table];
Initial Catalog=[Test_Table];
User ID=[sa];
Password=[xxxxxxxxxxxxxxxxx];

I get this error message

[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access
denied.


I made sure that IUSR_Servername grant access to the test_table database.

[rhabyan]

Try changing your data source to the server name you are using eg.: Data
Source= . That is a period if you are using the sql server on your local
machine or you can use Data Source=(local) if that is the name of your local
sql server. Both are the same. I don't think you need the [ ] brackets
either. These are only used if you have spaces in the names. Ray