hello, i have sql server 2000 on my local machine (with enterprise manager etc). i want to host a website (on a dedicated server) which talks to sql server, but i dont want to buy another license for the server machine that i am going to host on (too much money!). my question is: is ther...more >>

Two weeks ago we lost Dynamically determine port configuration on the SQL Server client computers (Windows 2000 Professional) and Windows 2000 Advanced Server computers. I have several SQL Server that are named SQL Servers that connect without an Alias with the TCP/IP Server name and po...more >>

What is the function of SuperSocket binds the TCP ports, and how does it work? I have received several warnings in the event viewer about Supersocket info: (SpnRegister) : Error 8344. Please help me with the Supersocket functionally an error message. Thank You, Dan ...more >>

I have installed MSDE with SP3a with a instance name on a Windwos Server 2003 Enterprise edition. The install works fine. I installed the client software on a W2k en W98 client PC, the install work fine. When i run the program, the program normaly sees the servernaam and instance name. ...more >>

I'm trying to link to a SQL Server 2000 server (A) that has Windows only authentication from another SQL Server 2000 (B). I am a System Administrator on both boxes and we use Active Directory. When I try to link to A from B, I get an error: Login failed for user '\null'. Reason: Not associ...more >>

I keep receiving the following error: The connection to SQL Server 'DERSET' has been broken broken? Do you want to try to reconnecting to it? What causes the error listed above. Thank You, Mike...more >>

[Microsoft ODBC ][SQL Server Driver][SQL server] Login failed for user '(null)' Reason , not associated with a trusted SQL server connection. This is on my (local) server. I tried changing the settings to where it will accept both windows and SQL authentication. I created a user account o...more >>

While I am connecting to SQL server 2000 EE from a different client machine using Query Analyzer it gives me the following error message . Unable to connect to server > Server : MSG 18452 Level 16 state 1 [Microsoft ODBC ][SQL Server Driver][SQL server] Login failed for user '(null)' ...more >>

I am running V5R2 on client and am trying to link a 400 from SQL Server 2000. Can this be done using IBMDA400? I have gotten to a point with the IBM DB2 UDB that I can connect without error. But now I can't see my tables. This is what I am using for my provider string: User ID=USERNAME;...more >>

I'm running Server 2003 (with Active Directory) and SQL Server 2000. I see SQL for a while from a client computer but then seem to lose my connection. At this point, if I try to connect I'll get the "Cannot generate SSPI Context" error message. It seems like I'm fine as long as I keep Query An...more >>

I cannot connect to a SQL server using win 98. Win XP pcs connect fine. This what I have tried: I renewed IP. I made sure I was logged into the domain. I tried connecting using both the ip address and the name of the eznotice server. I updated MDAC. I can ping both the ip address and t...more >>

Hi I'm using MSDE 7.0. When I execute the stored procedure (in Query Aalyser as well as in application sp_tables @type=TABL it gives out an error as 'type' parameter not found. But, the syntax specifies the 'type' parameter. Not only, 'type' but other parameters for the same stored procedure ar...more >>

Hello everyone! I try to setup a linked server connection to an other SQL Server and receive the following error message: Error 7399: OLE DB provider 'SQLOLEDB' reported an error. OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005: ]. I am using...more >>

im the admin of a small lan, ready to pull my hair out. New software package that uses sql server 2000 w/sp3a (standard server 2003) the writer of the software says its a dns error or something else, i checked dns and it looks ok. the error is.. ADO/RDS Error Description = The connection cannot...more >>

SQL server seems to be having problems writing to another sql server database server behind a firewall. The ip address is able to be pinged through the firewall but trying to access sql server gives "server does not exist or access is denied" message. The firewall has been setup to allow...more >>

SQL server seems to be having problems writing to another sql server database server behind a firewall. The ip address is able to be pinged through the firewall but trying to access sql server gives "server does not exist or access is denied" message. The firewall has been setup to allow...more >>

My connection to a local machine running MSSQL Server has failed. I'm trying to set up a datasource using ODBC through the ColdFusion Administrator. I've successfully set up a ODBC datasource DSN in the ODBC control panel using windows NT authentication. But when I try to use SQL server...more >>

Hi All, I am new to SQL Server world. We have Novell network in the office. SQl server is installed on Win 2K server and my workstation is windows 2000. How do I maintain (create tables, index, jobs, etc...) database from my workstation? Do I need any client software? Thanks. ...more >>

Using linked servers in SQL 2000 for some reason changes the commit mode when doing an INSERT or UPDATE. That means that journaling needs to be active on the tables that I am access on the 400. The 400 people have said no. If I do a straight ODBC connection, not through linked servers, ever...more >>

Is there a way to tell SQL Server 2000 which database you want to connect to at the time of login? I have two different database on my server and there are times I want to log into the other database instead of the default database. Can do this at login time?...more >>