sql2000

kshama parashar

16y3.7k

I am new in asp..i am making a project in asp..

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/intro/saveuser.asp, line 27
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E; AskTB5.3)
Page:
GET /intro/saveuser.asp
Time:
Friday, February 26, 2010, 10:54:39 AM
More information:
Microsoft Support

Know the answer? Post it — somebody with the same question will find it here.

Amit Choudhary16y ago
hi friend,

Data Source=(local)

Try give a DataSource name in place of (local) like your SqlServer Instance name..

Hope it solves your problem..
0
kshama parashar16y ago
dim conn
set conn=server.CreateObject("ADODB.Connection")

dim cstring
cstring="Provider=sqloledb; Data Source=(local); Initial catalog=kshama; Integrated Security=SSPI;"
conn.ConnectionString =cstring
conn.Open
0
Amit Choudhary16y ago
here is the source for your problem....

SSPI points to an authentication error connecting to your SQL Server instance.

have you tried creating a SQL Server logon and passing that to your connection string? If that works, then there's an issue with your Windows authentication.....

If it doesn't, then you have a more general problem connecting to your database
0
Amit Choudhary16y ago
hi friend,

post the few lines of code for /intro/saveuser.asp, line 27

Check your connection string also for datasource..
0
kiran kumar16y ago
refer this http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx
mark the answer if it helps you
0