SQL Server does not exist or access denied

[Aruna]

objConn.Open("Provider=SQLOLEDB;Data Source=ITSSQLDSN;User Id=joynerlm;Password=general")

I installed SQL Server on my system. Database is ITSSQL and DSN is ITSSQLDSN.
When I run my ASP code it is giving "SQL Server does not exist or access
denied". Why?

[Harish Kumar]

Since you're saying the particular database is there, the error could be probably
in the string that you're trying to open with. Why don't you create a UDL
file and then copy the connection string from there? You can create UDL file
in the following way -

1. go to desktop
2. right click and select text document
3. save the text document as UDL file - for example "harish.udl"
4. go to provider tab and select the driver
5. go to connection tab and select yr server & database
6. test connection and when it says ok come out
7. now right click on the icon and open the UDL file with notepad
8. copy the string and get started.

HTH,
Harish


"Aruna" <arunavennapusala@hotmail.com> wrote:
>
>objConn.Open("Provider=SQLOLEDB;Data Source=ITSSQLDSN;User Id=joynerlm;Password=general")
>
>I installed SQL Server on my system. Database is ITSSQL and DSN is ITSSQLDSN.
>When I run my ASP code it is giving "SQL Server does not exist or access
>denied". Why?
>
>
>