Reinstalled SQL-server

[Kent Johnson]

Hi all,

After I reinstalled my SQL-server I cannot use my ASP page with:
====================================
Set Conn=Server.CreateObject("ADODB.Connection") conn.Open
"Provider=sqloledb;" & _ "Data Source=test.my.company.se;" & _ "Initial
Catalog=MyDatabase;" & _ "User Id=sa;" & _ "Password=SaPwd;" set
rs=Server.CreateObject("ADODB.Recordset")
====================================
I have the user on the server.
What can be wrong?

/Kent J.

[Islamegy®]

You mean just install SQLServer only.
if you get login failed error you may need to Configure your sqlserver to
use MixedMode Authontication or u have to use trusted connection.

or you hv problem in IIS? try to run
"C:\WIN\Microsoft.NET\Framework\v1.1.4322\aspnet_r egiis -i" may help

"Kent Johnson" <08********@telia.com> wrote in message
news:o6*********************@newsc.telia.net...

Hi all,

After I reinstalled my SQL-server I cannot use my ASP page with:
====================================
Set Conn=Server.CreateObject("ADODB.Connection") conn.Open
"Provider=sqloledb;" & _ "Data Source=test.my.company.se;" & _ "Initial
Catalog=MyDatabase;" & _ "User Id=sa;" & _ "Password=SaPwd;" set
rs=Server.CreateObject("ADODB.Recordset")
====================================
I have the user on the server.
What can be wrong?

/Kent J.

[kunal]

Did you check the Provider , is the provider installed perfectly.
Is the object being created perfectly

[Kent Johnson]

Hi,
Maybe your right!
Where can I check the Provider?

/Kent J-


"kunal" <ku**********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Did you check the Provider , is the provider installed perfectly.
Is the object being created perfectly

[Kent Johnson]

Yes, I just reinstalled SQL-server so I figured that the problem was there.
"Islamegy®" <Is******@Private.4me> wrote in message
news:#c**************@TK2MSFTNGP09.phx.gbl...

You mean just install SQLServer only.
if you get login failed error you may need to Configure your sqlserver to
use MixedMode Authontication or u have to use trusted connection.

or you hv problem in IIS? try to run
"C:\WIN\Microsoft.NET\Framework\v1.1.4322\aspnet_r egiis -i" may help

"Kent Johnson" <08********@telia.com> wrote in message
news:o6*********************@newsc.telia.net...

Hi all,

After I reinstalled my SQL-server I cannot use my ASP page with:
====================================
Set Conn=Server.CreateObject("ADODB.Connection") conn.Open
"Provider=sqloledb;" & _ "Data Source=test.my.company.se;" & _ "Initial
Catalog=MyDatabase;" & _ "User Id=sa;" & _ "Password=SaPwd;" set
rs=Server.CreateObject("ADODB.Recordset")
====================================
I have the user on the server.
What can be wrong?

/Kent J.

[kunal]

So is the problem solved....

Kunal Ramesh Lalwani
Software Developer (ASP.NET 1.1)
Fahm Softwares
India