msde connection problem

Discussion in 'Database Support' started by isheikh, Feb 3, 2004.

  1. isheikh

    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

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services