By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,683 Members | 1,597 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,683 IT Pros & Developers. It's quick & easy.

Access to sql2005

P: n/a
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

May 30 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On May 30, 2:08 am, vaishalike...@hotmail.com wrote:
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
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

May 30 '07 #2

P: n/a
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
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
May 30 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.