Hi I'm having problems connecting remotely to my sql 2005 server sql instance is atl64\compaq ip is x and i would like to use a different port let's say 62322 how do i configure my server and how do i connect using either sql query analyzer or Sql server management studio i tried to ...more >>

Is this possible. To explain myself, here is my situation. I created an Excel Spreadsheet that uses an ODBC link to a SQL database. In order for anyone to use this file on their PC, that same ODBC link must be setup. Is their some code I can use within a Select Statement that will allow me...more >>

I'm running the Develpers version of SQL Server 2005 on my developer machine. I want to test an application from another machine but can neither log on nor use the SQL Server Management Studio from the remote machine unless I turn off the Windows Firewall on the development machine. (I made su...more >>

Hi there, Im trying to use SMO to impersonate a typed (not logged) user, using Windows Auth to connect SQL Server! Even though, I'm having many problems while trying to trace the exception I got! If you manage to perform a Windows Auth connection to SQL Server using an inputte...more >>

I am trying to connect to a SQL Server 2005 instance from another machine using Query Analyzer (SQL Server 2000 version) and I am getting the following error: Server: Msg 11, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. I can connect to other SQL S...more >>

We are having a website that generates postscript files when an order is placed on it. These files are placed in a folder on the network. I have been told to Load the postscript files into an existing sql database and then delete the file from the folder. If anyone has an idea on how to l...more >>

I have an application that uses SQL Server and can be run on mutiple computers over a local area network. One of my clients has requested to have SQL Server running at their main office and have each client machine at a different location connecting to SQL Server over the internet. I have been...more >>

I am trying to move our SQL 7 to standard SQL 2005 (64 bit) on a dual processor 64 bit Server2003. I need to link to DB2 400 data. I installed HIS (+$5,000), but could not get it to work. I removed HIS and upgraded to SQL 2005 (64bit) Enterprise with Microsoft OLE DB Provider for DB2. T...more >>

I never, ever cross-post, but I am desparate. This was placed in the sqlserver.server group earlier today. I installed SQL 2005 on a new machine last week. Created a database using scripts. Worked fine for a few days. It's not on my machine, but on a Win2003 Vitrual Server instance which I g...more >>

Hi, I've installed Visual Studio 2005 pro SQL Server 2005 dev on a WMCE PC. When I try to connect from VS to SQL I get the following error: ---------------------------------------- A connection cannot be made to the database. Set and test the connection string. An error has occurred w...more >>

I'm trying to connect to the SharePoint MSDE database from Windows XP SP2 machine over Ethernet LAN. I was getting server not found or access denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting OK Connection failed: SQLState: '01000' SQL Server Error: 10061 [Microsoft][ODBC SQ...more >>

I noticed when connecting to SQL Server using the SQL OLEDB provider that a number of SET commands are issued. In particular SET CONCAT_NULL_YIELDS_NULL ON is issued, and I'd like to change that to OFF. I've set the database option to turn this off by default, but all of the client conn...more >>

Have an MSDE named instance which works just fine. Just installed another instance of the same and can only connect to it using OSQL locally, nothing across the network. I made sure to use all the gotcha flags during install to enable network access, etc: setup.exe DISABLENETWORKPROTOCOLS=0 ...more >>

Is it possible to register remote SQL Server 2005 in SQL Server 2000 Enterprise Manager? Thank you Al ...more >>

In my connection string when using Data Source=ServerName I can get a connection to SQL Server. However, I can't connect using (local),(localhost),local or localhost. Is there any reason why this would work for SQL Server 2000 and not for 2005? Are there specific configuration setting I need t...more >>

Hi, I have installed SQL Server 2000 on a Windows Server 2003 machine with an instance name of "TestDB". But I cannot connect to this instance from another machines. It doen't even show up in the Enterprise Manager's "Register SQL Server" window. But if I use the default instance, it wor...more >>

Is it possible to restrict access to SQLServer only to selected applications (the ones I develop)?. This is why I'm asking: Suppose user "Mary" has access to certain tables for SELECT, UPDATE, INSERT, DELETE, etc. I want Mary to delete records on tables only in certain conditions imposed by my...more >>

Does SQLServer 2005 Native client support windows 98? Thanks ...more >>

I am new to linked servers and basically I want to query data from several tables on server A and then insert that data into a simple table on server B. I am hoping to do this from within a stored procedure on Server A rather than writing a small app. My limited research has been telling m...more >>

I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do I need to start? For example. I would like to have a cell in Excel that gives me the sum of Sales Orders in my SQL Database. I would also like for this to be able to change according to a date field in excel that c...more >>

Hi, I'm fairly new at SQL access from an ASPNET webform and cannot seem to get the SqlConnection string to work properly. I'm running VStudio, C#, IIS 5.1, MSDE sqlserver, Net 1.1 framework. The connection code that causes the error is: SqlConnection conn = new SqlConnection("Data Source=MYSER...more >>

In my database I created a SQL Server user - malphaTest In my WebConfig.xml <add key="SQLConn" value="Data Source=HIDSCFILE002;Initial Catalog=Membership;User ID=malphaTest;Password=12345;Trusted_Connection=False"/> </appSettings> The error returned when press the search button to quer...more >>

Hello all, I got a application which is developed using VB6.0 as front end and MS-Access as backend. Now i would like to change the database from MS-Access to MS-SQLserver. How do I change the databse from MS-Access to MS-SQLServer? Regards Jack...more >>

I had a beta version of visual studio 2005, including SQL Server 2005, on my PC. i have uninstalled these and now installed VB an d C# express but when I try to install SQL xprs 2005 it tells me I have some beta stuff left. anybody know what I should be deleting?...more >>

Hi all, Does the software support this? a linked server to sql2005 from sql 2000 server? I keep getting error of "The user is not associated with a trusted SQL Server connection." or "Server not found". So i like to know if it is doable fiest before i go crazy trying to fiqure out where it i...more >>

I have VS2005, SQL 2000, SQL Express and SQL 2005 installed on my laptop with XP Pro. I have no problems connecting to SQL 2000 but get the following error when I try to connect to SQL2005. "When connecting to SQL Server 2005, this failure may be caused by the fact that under the default s...more >>

Hi I have a SQL Server 2000 database that I can connect to from an ASP.NET web site quite happily. Using the same connection string in a Windows Forms application I get the message "When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL...more >>

I've installed Visual Studio 2005 (including SQL Express) on a XP Home machine. I've currently problems to connect to the SQL-Server getting the following error message C:\Dokumente und Einstellungen\Robert>sqlcmd HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connect...more >>

Hi, I've installed MS SQL Server 2000 Developer edition on Windows XP professional running on Virtual PC 2004. I am unable to connect to sql server running on a physical machine or ot the sql server instance on the virtual machine itself. I get the following error: " Unable to connect to ...more >>

hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was installed during the installation, finally trying to get an sql database to work, i am a newbie to both Visual studio and SQL, anyway i can see the database inside server explorer and all its talbles, but when i try to ...more >>

We have 4 instances of SQL running on 4 different servers. We recently had to change our administrator password. After doing that, we cannot connect from our computers (Windows XP SP2) to any of our SQL servers (1 Windows Server 2000, 3 Windows Server 2003). We see the following error: A c...more >>

Hi, I have a very odd problem: I CAN connect to a MSsql2000 server on a remote machine with username and password (i.e. without windows authentication) from a sql quary like program (its called sqlBuddy). So I know the server is running and I have acces to it. But when I try to connect to the...more >>

I need to connect to an Oracle database (8i) running in a UNIX box, with SQL Server running in AD. If anyone has done it, kindly let me know since this is new territory for me. Thanks, Neil...more >>

Is there a way to use Windows Authentication to log on to an SQL server instance accross a peer to peer network without a Domain? ...more >>

Hello all, I need to write data from one SQL server in to a linked server running on an other machine. How can i check with T-SQL commands if this server is available? If it is not available the stored procedure directly quits with an error. But this procedure should continue in differt w...more >>

Can we remote connect MSSQL 2005 express with IP address? If can how to done it? With regards, Goh ...more >>

I have a working SQL Server 2000. I use Citrix to run Terminal Server Apps which work Fine. If I use RDP instead of ICA (Citrix) using the same app and the same user, I get an error as follows: "[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or access is denied." As I sai...more >>

Hi, Trying to make a new database project using VS2005 pro and SQL2005 dev (in my local machine), I get the following error and the project can't be made: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by...more >>

I have a Window 2003 SBS with SQL installed (SQL 2000 includet in SBS). Everything worked fine for a long time, but now the SQL server starts but the SQL agent doesn't start even manually. When I try to start the agent it is trying to connect but it doesn't. In the log it says that it start...more >>

I can set up a linked server to a FoxPro DB in SQL 2000 but it fails when trying to set up the linked server in 2005. I know the MS site says something about leaking memory with the linked server but I don't even get a link that works. Here is what happens in a Win2003Server, SQLServer2005...more >>

Hi everybody, I have two DataBases on different SQL2000servers, I have linked them both, and what I want is, when a record is created on one DB it must create the same record on the other DB. If the DB's are on the same server the trigger works fine, but when they are on different servers(c...more >>

I have two servers, the sql agent service on both servers are running under a domain account - rrg-sqlagent which is an administrator on both servers. The initialization of the database works but 15 minutes later when the the log shipping starts to occur i recieve the following errors. does an...more >>

Hello! Does a client that connect to an SQL 2005 analysis services always need .NET framework 2.0 installed? Regards Clarkie ...more >>

I have 2 SQL Server 2005 machines each with a .NET2 web app. Machine #1 is Windows XP Machine #2 is Windows 2003 When I use EM on Machine #1 to connect to both instances everything is fine (and fast). When I use EM on Machine #2 to connect to both instances, the server on machine #1 is v...more >>

We just upgraded from SQL 2000 to SQL 2005. To do so we had to uninstall SQL and install 2005 from scratch. The problem now is we get this error: Msg 3910, Level 16, State 2, Line 1 Transaction context in use by another session. When trying to Exececute a SP on a remote server where that S...more >>

Dear all, I am new to SQL server 2005. I have a connection problem when I connect from home client to office server through VPN. Firstly, I can connect from office client to office server, both datbase engine and analysis server, with Windows authentication. I log in the office client box with...more >>

I'm moving my intranet app from one development server to another. The old one was Windows 2000 Server with SQL Server 2000. The new one is XP Pro with SQL 2005 Express. here is the connection string I have been using on the old machine for years: strDBConnection = "Provider=SQLOLEDB;Persi...more >>

I have an instance of SQL Server 2005 on two different development machines. At first we could not connect to Machine A until we read about how it comes locked down. We went to SQL Server Config Mgr and enabled all necessary protocols and can connect just fine to it. When we did the same to ...more >>

Hi, DevStudio 2003, SQL Server 2005, Windows 2000 Pro SP4 I have been using the Enterprise Library Data Access Application Block to connect to a local SQL 2000 database. The connection string parameters are: <connectionStrings> <connectionString name="Temp Connection String"> <parame...more >>

Hello Again All, Thanks again to Rick Byham for your seggestions. Ok I started SQL Management Studio and loged in using Windows Authentication then I ran the query ALTER LOGIN sa ENABLE ; GO ALTER LOGIN sa WITH PASSWORD = '<password>' ; GO Then I closed the SQL Management Studio and...more >>