I created an event sink on exchange serve using VB.Net. It can fired and add data into the SQL 2005 when the exchange server has Visual Studio 2005. When I install the component on the test exchange server in which Visual Studio 2005 didn't installed, there is time out issue. I have confi...more >>

Hi! I'm looking for a way to retrieve Licence Info from SQL 2005 Server with VBScript From a remote location I connect to the server and grab those info with my administrative rights, but I'm not accessing the DB with a SA account... With SQL 2000 Server I retrieved those info from regi...more >>

I have my sql server 2005 in DOM1 and my desktop (sql 2005 client) is in a second domain DOM2. The sql server runs under DOM1 domain admin acount. I have a DOM2 domain logon which I use to log in my XP, Using sql authentification works fine, but very soon I need to use Windows integrated s...more >>

Hi I installed ASP and MSSQL(SQL Express Edition, SQL Manager 2005 for SQL Server Lite). - ASP is runnig correctly - With SQL Manager 2005 for SQL I can create Databases and tabels and some records... I can not connect from an ASP script (example follows at the end). I've get an error ...more >>

I am connecting to a remote SQL Server database from Visual Studio .NET 2005. I have an sql script located on my machine containing the sql code I want to use to create several tables, and want to execute it. How can I do this from Visual Studio .NET 2005? I do not like designing the database ...more >>

Hi All I have set up several linked SQL servers which work ok - but I'm having trouble setting up a linked server via ODBC (in either SQL 2000, or 2005). The ODBC points to an 'Alchemy' database and uses an Alchemy driver ironically i can set up linked tables in an Access DB, via ODBC - an...more >>

Hi, We are developing a small web interface to a local ERP software, which uses SQL Server 2000 as database. The database uses SQL_Latin1_CP1 collation, and the fields are varchar (not nvarchar), however, the main program inserts and reads non-English (Turkish) characters into these columns. Ho...more >>

I've got SQL Server 2005 installed on my PC, set to mixed-mode authentication. For months, I've been logging in to Management Studio using the "sa" account. Recently, something changed and I can no longer do that. I get the following error: "A connection was successfully established with the s...more >>

Hi, I am installing MSDE 2000 on client machines. Where can I dowload the client connectivity tools for MSDE so that users can see and work with thier databases? Do I have to download sql sp4 for that? Can someone please send me the link for downloading the client tools? Thanks -- ...more >>

I have installed Sql Server 2005 Express on a Windows XP PC running SP2. The Windows Firewall has ports 1433 and 1434 opened. I ran the Sql Server Configuration Manager to set the Protocols for SqlExpress and the Client Protocols to TCP and port 1433. Restarted the PC. Verified teh services ar...more >>

Hi All, I can not connect to sql serve 2005 using SQL Serve Management Studio, I got these error in ERROR.LOG file. Any help is really appreciated. Thanks. 2006-09-21 12:48:21.53 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyrigh...more >>

I have just started using SQL Server 2005(last night). I currently have an internal network with my client machine(development) and a server machine(sql server 2005). The SQl Server install has all the default settings, and I turned on remote connections. But when I go to connect to the serve...more >>

Hi, SQLServer 2000, using an OPENDATASOURCE command within a stored = procedure to access data on another Server running 2000. I get the = following error, when I exececute the Stored Procedure in Query = Analyzer: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options = t...more >>

I have a small utility that is used to run sql script files from command line. It's created in c#. This utility uses sqldmo objects to connect to server and run script. I have two SQl server instances installed - 2005 and 2000. I'm using 2005 as a default instance and 2000 as .\sql2000 named ins...more >>

Need Help! Connection Count to Linked DB2 Server Reaches limit (SQL1040N) when execute dynamic generated OPENQUERY T-SQL Hello, every body. I created a linked server to DB2 8.1 database which called GRR_DB2Server. In my stored procedure p_FetchRawData, I need to read some data from this lin...more >>

Hi Folks, I'm new to the MS SQL Server world. Couple quick questions: 1) Can I use the current version of Mangement Studio Express (MSE) to create/update/delete fields/tables on an existing SQL Server 2000? 2) How do I get connected over the 'Net? I have created an ODBC syst...more >>

Hi, I am developing an ASP.NET 2.0 application and SQL Server 2000 as back-end. The connection to DB works fine if I connect to my local or our dev databases. It is giving me the error when I try to connect to Test database. However, I am able to connect to the same database through Enterpris...more >>

We are running a cluster with SQL Server 8 on Windows 2000 advanced server. Recently, we changed the IP address of just the virtual server, for the cluster. Not long after we were unable to connect to port 1433. I checked in the regestry and the cluster setting is pointing to the old IP a...more >>

I have MS SQL server desktop version installed localy and I have been using it till last time I had to change my windows XP password. After that I could not start service and I am getting an error message: "The service did not start due to a logon failure", and "An error 1069 - The service did...more >>

I know there is quite a lot of posting before for this error. And I quite confused with long explanation at Microsoft Support. My problem is quite weird, I can connect normally to SQL Server (running Windows Server 2003) from my PC (running Windows XP SP2) for around half to one hour. I develop ...more >>

I have an application (winform vb.net 2005) installed on some computers. There is a connection to an sql server on the companys server. This works OK on all machines except one, where I get the message 'TimeOut on trying to connect to sql server.' ( A combobox with data from a table on the sql s...more >>

I have installed SQL Server 2005 (Developer Edition) as a default instance onto a Windows XPpro (SP2) machine and I am trying to connect to it from another Windows XPpro (SP2) machine using Microsoft's DataLink connection tool. I have installed using Windows Authentication only for the default ...more >>

I'm running SQL 2005 in a classroom environment. Whenn several students log-in at the same time via Management studio we get this: SQL Execution Error: Executed SQL statement... Error source: .NET SQLClient Data Provider Error Message: A connection was successfully established with the serve...more >>

Hello I am new to SQL Server / MSDE ... Strong with MS Access I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and on a Windows 2003 Server (WEB Edition). I have simplified the problem by trying to access the database only on the local computer (DEVELOPMENT). I tried...more >>

I installed SQL 2005 Standard on Windows 2003 R2, and when I connect to the server (no firewall involved) using Remote Desktop, I can't login to Management Studio using the local administrator account. However, I can log in using the domain administrator account. The local administrator accoun...more >>

If the TCP/IP is set to Listen All, what does it mean when a specific value is entered against TCP Dynamic Ports, and which is not 0? I checked the documentation and I can't find anything to say what that would mean. I thought it might be the specific port on which SQL Server is listening, but...more >>

I'm trying to link SQL Server 2000 to DB2 UDB 7.2, using OLE DB. However, I've gotten an error message stating that the DB2 OLE DB provider I'm using does not implement a required interface. I've also read that there is a Microsoft DB2 OLE DB provider, but I can't find it. Does anyone know ...more >>

Hi I wounder what the difference is between the programs SQL Server 2005 Enterprise Edition and SQL Server 2005 Developer Edition? And I wounder if the book "Microsoft SQL Server 2005 Express Edition for Dummies with CDROM" is good for me to learn about SQL Server 2005. I don't understand why t...more >>

A linked server definition in MSSQL 2000, can succcessfully authenticates with a UDB database v8.1.0.61 on a SUN box, but then gets access denied, eventhough the account being used has DBADM authority. However, I can successfully authenticate and query the same UDB databases from a DOS DB2 ...more >>

Hello, We are experiencing a frustrating problem where we can connect to an internal SQL Server via any application EXCEPT Office apps (Excel, Word, etc.) using VBA. The error is: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. We're using very elemen...more >>

Hi I have just installed SQL Server 2005 Enterprise Edition. I have Microsoft Windows 2000. When I start SQL Server Management Studio and have to choose a server from the Server name list, the list is empty. I have no clue what to do? Please Help me!!! Explain carefully Fia ...more >>

I installed SQLServer 2005 with OS winserver 2003. When connect to SQLServer 2005 i have received message: "Microsoft SQL Server, error 233". pls help me. thank you very much *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, Let me outline what I have and maybe someone will know how to react to what is happening to my system. Server: Windows2003 Standard SQL: SQL 2005 Demo and SQL: SQL 2005 Processor Licensed (connecting via port 14330) Additional Major S/W on that server: Sophos We have run out the dem...more >>

Hi Guys, <Posted yesterday to microsoft.public.dotnet.framework.aspnet.security, but no responses garnered. For mpsc readers, this is a fairly common error encountered when connecting from ASP.Net 1.1, but I've followed all the help I can find online and it hasn't fixed my problem yet. So any...more >>

I setup the SQL2000 db to listen to the default and additional port 5000 through the server network utility. i go and do the netstat -a in command prompt and i don't see sql server listening for those ports, i open the log files and it is not listening, what is wrong? Could it be a corrup...more >>

Hi Here is my scenario: Developing a Windows app in VB on VS2005 with a SQL Express db. There are 2 developers (Developer1 and Developer2) working on this app, only 1 working on it at any one time; we zip and email the source code and mdf/ldf files to each other at the end of a day. Both m...more >>

Using Windows Server 2003 Standard, and SQL Server 2000 Standard SP4 on the same personal development PC to test a newbie web service connecting to a local database from an C:\Inetpub\wwwroot web site (local machine). I am unable to get a good connection, with the connection strings shown bel...more >>

Hi, on our server we have a default SQL 2000 instance and also another MSDE instance with the name server\instance1. In one of my database of the default instance I would like to create a view to the table from the another instance. I have tried with select statement like SELECT * FROM...more >>

I am not been able to connect to SQL Server with Enterprise Manger as I increased the number of databases upto 170 .Earlier i had no problem when I had less of databases .Moreover there is no problem in connecting through Query Analyser. Could any one help please ? Regards Musharraf Sulta...more >>

Hi All, I'm attempting to connect my .asp page to an SQL 2005 server and I'm receiving the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection. The SQL server is set for mixed authent...more >>