msde connection problem

isheikh

Guppy
Hi,

I can not connect to MSDE from my ASP page and keep geting this error. When I installed MSDE i did not set the password and user name is still at default 'sa', Can some one tell me why i get this error...

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied




My code is asp to connect is

objConn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=iffo;Data Source=local;Initial File Name=D:\Program Files\Microsoft SQL Server\MSSQL\Data\iffo.mdf"

thanks
 
Back
Top