I have the SQL 2000 desktop version on my Xp pro Sp2 machine and have installed IE7. Now when I open Enterprise Manager, I get: A connection could not be established to (LOCAL). Reason: SSL Security error ConnectionOpen(SECDoClientHandshake()).. Help! -- John Austin...more >>

Dear all My SQL 2000 enterprise run on win2000Advance server, and 8GB memory, 4 CPU. one problem, i discover i connect sql server is timeout suddenly. So i check the CPU ultilization is 4%, and the memory so low view from task manager. could you tell me what problem happen and how to trobles...more >>

Hi, I developed a programm with dot.net 2.0. On my environment ervy thing works fine. When I try to use it on the customers envrionment I get the following error message: "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failuer may...more >>

Hi all, I've been fighting to get sql server express on my machine to be accessible remotely. I've tried many times and quadruple checked all of the instructions in KB article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 I have even performed a full uninstall and reinsta...more >>

Am new to Sql Server Express but using it doesn't seem "easy" . When executing a very simple sample program in Visual Studio 2005, this message occurs: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be cl...more >>

Hi, My application in another server can't find the SQLServer database after a restore. The name of the DB is exactly the same! The application says the the Target Database does not match destination database. My question is: Is it possible that the reason comes from the database eve...more >>

When I try to connect to an external SQL Server via enterprise manager I cannot seem to connect to a named instance. In the past this has worked with no problem when I do ip\instance. However when I now try I am getting invalid instance name. The name I am using is correct. I am connecting fro...more >>

some of my colleagues need to connect to my database to retrieve some reports but they can't connect to my computer. i didn't set any specific passwords as i'm using my window account ( username - Administrator , password - ** ) during the nistallation but the system always show "Connection to...more >>

I am trying to make a unique logon to a SQL server in an Access apd file so when the file is executed it logs into a specific database. I set up the new user name and password in the SQL server and associate it with the database giving it read, write and admin privileges. In the Access file ...more >>

When I open SQL Server Enterprise and try to connect via my SQL Server Registration, I get the error message “SQL server does not exist or access denied”. If I try to modify the Registered SQL Server properties, I get the error message that it failed to connect for the same reason. I c...more >>

I have a chunk of code which is essentially IDbCommand cmd = db.CreateCommand(); cmd.CommandText = "SELECT X, Y, Count(*) FROM Foo WHERE Z = 1 GROUP BY X, Y"; using (IDataReader reader = cmd.ExecuteReader()) while (reader.Read()) { // grab values from query } The database is...more >>

I got sbs 2003 server with sql 2000, and using backup data function to move the database to another 2k server w/sql2k, after I restore on the 2k server, I from workstation try to login by using that data, but there is no account appear on the screen. What is wrong with it or I did something...more >>

Dear all, I have built a SQL2005 64-bit developer edition with SP1 on windows 2003 Enterprise 64bit. I try to use a 32-bit XP client to connect to SQL2005 server but fail. It seems the SQL server does not exists. I have tried to use the Query Analyser to connect to SQL 20005 but still fa...more >>

I just changed my network password and cannot connect to SQL Server. I get the following message: An error 1069 - (The Service did not start due to a logon failure) occurred while performing this service operation on the MSSQLServer service. I went into Enterprize Manager, right clicked o...more >>

Hi guys, i can't connect to my sqlserver 2000 with isql : isql -Slocalhost -U<username> -P<password> The sqlserver (no name, displays (LOCAL)) is running on the local box, i can connect with EnterpriseManager and QueryAnalyzer. Everything seems ok, but isql cannot connect (error message is so...more >>

Ok, here is the situation... I have created an Access Project application which connects to our SQL Server. SQL server is not behind a proxy, it listens to the default port Most of our users are outside the LAN and thus they connect through the internet. One of our users works in a university ...more >>

Hi, For some reason I can't connect to a (remote) SQL server using SQL server management studio (2005) from my local SQL 2005 Server. I can connect from numerous other PCs/Servers in my site except this one. The local SQL Server is running Windows 2003 R2. It will accept the username (sa...more >>

I have a SQL Job setup in SQL2005 that when there is something to report, via a stored procedure, an email will be sent out via database mail. Whenever it tries to send an email it fails with this error: [SQLSTATE 01000] (Message 2528) Query execution failed: Error initializing COM [SQLST...more >>

Hello, When attempting to connect to a SQL DB through an Access front-end, I receive the following error: Connection failed. SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL...more >>

I use VPN to connect to corporate network from home. VPN works fine and I can use remote desktop to access the SQL box.. BUT, I am only allowed to use trusted connections for SQL. I am developing applications at home PC (XP Pro), which is not part of the domain. Is there a way that I can conne...more >>

Hi I have two machine one is application server (asp) and one is database server (sql 2000). Between them, I use a crossover cable connect each other(1GB) and also they' re all connect to internet use another network card(100 MB). I test locally and the speed is good, but just found i...more >>

Hello, I am dealing with an issue, that although probably simple, is driving me crazy. I am trying to connect to a SQL 2005 Express database through a web service using the following code: [WebMethod] public XmlDocument GetAllAuthors() { XmlDocument doc = new XmlDocument(...more >>

At 2:00 AM every other morning we are getting errors that are causing us to have to restart SQL Server 2000. The event log registers the following: Source: MSSQLSERVER Event ID: 17052 Error: 17825, Severity: 18, State: 4 Could not close Net-Library ''. We will also see the following erro...more >>

I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled tcp/ip for remote connections. I also have SQL Server 7 on the same server. I can connect to the SQL Server Express instance remotely if I specify the dynamic port: sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -...more >>

Hi can anyone help me on this I am consistently getting the following error Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. /test.asp, line 7 The connection string which i am using i...more >>

I receive an error 26 "Error locating server/instance specified" when trying to connect to a named instance of sql2005 through sql server mgmt studio (i can connect locally just not from a remote pc). I can also connect via the old query analyzer to the remote sql2005 server. I have enab...more >>

I'm trying to install WSUS with SP1 on my SQL 2005 server. When I'm on the "Database option" page, the choice to choose an existing database is greyed out. It will only allow me to continue with the MSDE option selected. All of my SQL services are started as I have databases in use currentl...more >>

I have a new server with SQL2000. I have copied all my databases. Now I have to attach them. Their are abouth 300 db's So it is a lot of work to attach them one by one. Is their a way to attach them all in one time? Kees ...more >>

Is there a way to connect to SQL Server 7 using the new Management Studio? /Axel ...more >>

-- I have a problem, my internet connection seems to terminate with time. If I reboot my computer my connection is re-established, after the computer sits awhile, I'll get "cannot find server" again, strange. I was hoping someone could help me? This doesn't seem to correlate with any part...more >>

I'm using .NET 2.0 and SQL Server 2005 Express Edition on WinXP SP2. I'm using System.Data.SqlClient to connect to the server which is on the same machine. The SQL Server service is set to log on as "Built-in account: Local System" and the connection string I'm passing to the constructor is "D...more >>

Hi, I have 3 instances of SQL server currently on my machine. The default instance is MSDE 2000, I also have an SQL Express 2005 instance \MACHINE\SQLEXPRESS and I have an instance of SQL Server 2000 Workgroup Edition, named \MACHINE\WORKGROUP. When I execute SqlBrowseConnect or "ListAl...more >>

I am getting the following error when querying a linked server: Msg 7403, Level 16, State 1, Line 3 The OLE DB provider "Sybase.ASEOLEDBProvider" has not been registered. The query is as follows: select * from syb_Link.Comp.dbo.Users...more >>

I am having difficulty connecting to SQL 2005 Express from ASP Pages. My Web site is a mix of data driven ASP.NET 2.0 pages and some complicated ASP pages which I have not had time to migrate. I recently copied all the my data from SQL 2000 Server to SQL Express. My ASP.NET pages connect corr...more >>

Hello all! I have set up a SQL 2000 cluster and I have installed SQL 2000 Reporting Services on another server. Both servers are on the same IP subnet (10.10.100.x/24) and both connected to the same network switch. I cannot connect to port 1433 of the SQL cluster from the RS server. Howeve...more >>

Hello, We have a IIS server running and this server is not part of the domain on which the databaseserver resides. However, it is possibile to ping the IIS-server from the databaseserver and vice versa. I try to connect to the database with a trusted connection. What I have so far: set sCon...more >>

Hi All, I use the following code lines for connecting to SQL Server 2005 using JDBC in Java: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String connectionUrl = "jdbc:sqlserver://SERVER;user=USER;databaseName=db;AuthenticationMethod=auto"; but I got the ...more >>

Hi, I have a problem when connecting to a named sql 2000 instance . The instance is running in a 2 node cluster configuration. The second instance on the other node works fine. When I try to connect with a client on another pc, the connection only works when I set the correct (static) po...more >>

Under SQL Server Group, I have three registered servers: (local) (Windows NT) 192.168.100.5 (Windows NT) 2K-SERVER (Windows NT) Each server contains a database named "Admin" and each "Admin" database has a table, "Cases". In the following query, how would I specify the Server: SELECT...more >>

Currently, I access a database and table that is not the current database using Admin..CASES INSERT INTO Admin..CASES (CASE_CODE,CASE_NAME,CASE_CLASS_PERIOD_BEG_DATE,CASE_CLASS_PERIOD_END_DATE, CASE_DISTRIBUTION_DATE,CASE_URL) SELECT M.MailCode AS CaseCode,C.CaseName, C.ClassPeriodBegDate...more >>

All, To start off I have SQL 2005 SE Clustered in an Active/Active environment. Everything is working correctly as all websites and standalone applications are connecting and getting/sending data correctly using SQL authentication. My problem is that I have 1000's of developers that would l...more >>

I hope that I'm right here. We have an intranet-site in ASP where, till now the data was in an Access database and we connected to the data via DNS. Now we would like to change the data to a SQL-server. For me, it seems logic that logic that everything should work after creating a new DNS t...more >>

Hi I'm using the free MSSQL Database from Microsoft and the SQL Server Management Studio express to administrate the datas. However, I'm looking for a possibility to backup my datas. Of course it should be a no coast backup way;) If I'm not totaly wrong then I can't make a backup or a dump...more >>

Hi, I have a problem with a conection to Remote SQL Server Database wich have a blank space in databese name. Ex. "Production ED" I Can`t change the name of this data base. I Need to connect this database with a Stored Procedure in another Server. Both Databases are SQL Server 2000...more >>