Access to sql2005

  • Thread starter Thread starter vaishalikedar
  • Start date Start date
V

vaishalikedar

I have a website in VS2005 C#. Access to server is no problem in debug
mode.

Access in run mode gives an errror. What exactly do I need to do to
enable this?

Thanks and regards,
VK
 
I have a website in VS2005 C#. Access to server is no problem in debug
mode.

Access in run mode gives an errror. What exactly do I need to do to
enable this?

Thanks and regards,
VK
Click to expand...

What error exactly?

SQL Server 2005 doesn't take remote connections by default. Might this
be your problem? Take a look into Sql Server Surface Area
Configuration Tool
 
I have a website in VS2005 C#. Access to server is no problem in debug
mode.

Access in run mode gives an errror. What exactly do I need to do to
enable this?

Thanks and regards,
VK
Click to expand...

How are you connecting to the database? I'm guessing "integrated security".
When you run the site in the debugger, it could run under your account,
which has access rights to the database.
When you run it "for real" it runs under a local ASPNET (or NETWORK SERVICE)
account, which isn't known to SqlServer.

Solution: connect to SqlServer using a specified sqlserver account.
(note: SqlServer needs to be set up to accept both integrated secirity
and local accounts - which isn't the default)

Hans Kesting
 
Back
Top