473,786 Members | 2,615 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

May 30 '07 #1
2 1093
On May 30, 2:08 am, vaishalike...@h otmail.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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1804
by: ad | last post by:
The user of my asp.net program use Sql2005 or Sql2005 express as database, both are possible. I have try both version of data base, I found: If I use Sql2005 express, the Data Source in connection string will be ..\SQLEXPRESS, like: Data Source=.\SQLEXPRESS;Initial Catalog=myDB;Integrated Security=True But I use Sql2005 , the Data Source in connection string can be use (local), like:
2
1063
by: ad | last post by:
Hi, As title, After I install Sql2005 SepCTP, can I install VS2005 Beta2 in the same machine?
0
809
by: mtczx232 | last post by:
have a way to declare variable object of SQL2005 DB, and access directly to DB objects like call procedure or get lines from table without using with Fill or Execute?
6
1206
by: HK | last post by:
I have ASP.NET 1.1 websites. They will need to access a SQL 2005 database. Do I have to upgrade the whole web projects to ASP.NET 2.0 in order for them to access SQL 2005? If so, anyone have any good URLs for upgrading 1.1 websites to 2.0? I'm really worried about crashing the current websites if I do a quick conversion to 2.0, but I don't have much time before needing to access SQL 2005.
1
2744
by: r1100r98 | last post by:
I am having a problem moving the data from a datatable to the SQL2005 table (using VB2005). See code below. The SQL2005 table is empty, the datatable is being filled from a text file, not from the SQL2005 table. I have tried various ways, but the SQL table is not updating. Help would be appreciated. Code is below Thanks Imports System Imports System.Data
1
7126
by: anjali.lourda | last post by:
Hi, We are trying to use the accordion control from ajaxcontroltoolkit by databinding to an sqldatasource. The accordion binds to the datasource perfectly. However, We are not able to access the controls or their values which were bound. Please let me know which is the away to access that Given below is the code. Please let me know if any further information is required. Regards, Anjali
1
1276
by: srinit | last post by:
hi i am working on sql2005. i am trying to import database from access including relations by using SSIS.any one suggest me or give me the links. Thanks in advance.
0
1513
by: Realm Master | last post by:
I have a two computer workgroup. On my laptop I moved Access tables to SQL 2005Express and linked them. I use Access as the front end and everything works from the laptop. Both the access files and the SQL files are in the shared folder. I have given Everyone user full rights to the shared folder. When I attempt to use my desktop to access the linked access files the following error occurs on the desktop: Connection Failed...
3
2897
by: Michael Schöller | last post by:
Hello, First of all english is not my natural language so please fogive me some bad mistakes in gramatic and use of some vocables :). I have a great problem here. Well I will not use it anymore but I want to know why it is as it is ^^. I tried with .NET3.0 but I think it will be the same with 2.0 and 3.5. MSDTC is configured and working.
0
2004
by: nic829 | last post by:
Hi, I was upgrading a instance from SQL2000 to SQL2005. During SQL2005 setup I accidently allow the files to be installed in C drive, but I should have them all installed in D drive. My databases are still sits in D drive, but other files (Management studio, analysis service, etc.) all sits in C drive. Is there anyway that I can move SQL2005 from C to D drive? I thought of uninstalling current SQL2005, install it back and load current...
0
9496
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10363
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10164
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9961
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8989
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7512
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5397
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5534
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4066
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.