Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Asp.Net Programming

Access to sql2005


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

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

-----------------------------------------------Reply-----------------------------------------------

> 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

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc