After an office move (accompanied by IP Address changes), I can no longer use Windows authentication to connect to one of my SQL Server machines. Nothing else seems to have changed. This is an example of what I am facing. For simplicity, I conducted this with Query Analyzer, attempting to connect...more >>

I have SQL installed locally, and it has been working fine for some time. However, today when I went to Enterprise Manager I could see the tree view but as soon as I selected "Databases" everything froze, Task Manager reported that the application was not responding. I left it for 10 minut...more >>

I undstand that if you choose to dynamically assign a port number to an instance this is a once only operation performed the first time that instance is started and from then on it always attepts to use that port number. Having just started with a new company I'm trying to work out if instanc...more >>

I'm really looking for an explaination rather than an answer... I can't connect to sql instances on a specific server using the normal structure of <servername>\<instancename> but I can connect to <servername>,<portnumber>. I've tried many different connection tests (OSQL, udl file, Ent Mn...more >>

I have a VB6 client application connecting to a SQL2000 server(SP3). The program alway stops after it processes around 200 records in the table and getting a connection error. The client PC has MDAC 2.6 installed and other parts of the system doesn't encounter this problem. I had tried to...more >>

Hi Firends, I want to check that particular SQl Server instrance is running or not. SQL Server may be behind firewall and listening on PORT 1433. If a particular SQL Server becomes offline its status should be known. With regards, Lalit ...more >>

I am using the client install of SQL Enterprise manger to connect to my SQL server. I can open the server and view the DTS packages but when I try to view a transform data task or try to run a task or a package I get the following error. [DBNETLIB][Microsoft][ODBC SQL Server Driver]SQL Ser...more >>

Hi! I have an app, that uses BDE to connect to server. Recently I movrd the server to a named instance on a cluster. Due to some BDE issues the app stoped working. A workarounfd was found: to add an alias to a Client Network Utility: sqlserver -> node2\sqlserver. This is a greate pain ...more >>

Hi, Can somebody help me to fill a combobox with a field (ex: "Description") in a table (Ex: Countries)? Thank's ...more >>

I'm able to connect to connect to server using the netbios name but, if I connect using the FQDN I get the SSPI error...more >>

Hello! We are currently running SQL Server 7.0 with databases in 6.5-compatibility mode for DB-Library. - Will this still be supported in Sql Server 2005? - If so, any changes in behaviour? - What new features will we be "missing out of" by continuing with the above setup (db-lib + 6.5-m...more >>

Hi, I am using Windows 2003 Server. The VPN works fine, but I want to FTP through the VPN so the connection is encrypted. The problem is each of my IIS sites has a real Internet address specified, w.x.y.z. So when the VPN comes up using a private IP, I can't connect to any of the FTP sites u...more >>

Hey all, I'm connecting to SqlServer 2000 from an ASP.NET web application. The web application runs under a specific Identity (impersonating to a specific windows account), the connection string contains "IntegratedSecurity=SSPI", and as far as I can see, it (the connection string) is constant....more >>

We have an ascx User Control that makes sqlclient database connection to SQL-Server 2000. This user control is then contained on asp.net page for testing (we eventually want To use control in a web part). This control functions normally if it resides in an IIS 6.0 web site not configured fo...more >>

We are moving an Access2000 adp application to Access 2003. Access2000 version uses approle for security but we found Approle does not work the same in Access2003 so we are switching to a proxy security method. Problem We need a way for SQL to know the nt username that initiated the proxy c...more >>

I can't perform a distributed transaction between a remote server to the central server. I have 3 sql server 2000 enterprise edition. 2 of them are installed on win2K server (LOCAL1, LOCAL2) and the other (CENTRAL_SQL) is installed on clustering win2K server. None of them is in domain. ...more >>

I am working to replace our production SQL7 server on NT with a new box running SQL2000 with Win2k3. Last week I had prepped the new server by importing the db from backup, the jobs, DTS packages, and by (hopefully) restoring the user accounts - only 6 of them. The old and new servers are bo...more >>

Hi All, I have recently upgraded our W2K Server to W2K3 Server after applying SQL Server 2000 SP3a first. Since upgrading the server, all client machines (XPsp1) can connect and operate with the SQL database and also run the VB6 apps ok, but I (Administrator) cannot connect to the database ...more >>

Server: W2K server with SQL 7.0, all WU patches applied Client: W2K professional, all WU patches applied I have an application that resides entirely on the server, only a shortcut is installed on the client. It connects to SQL using mixed mode authentication. When I installed SQL server 200...more >>

Hello. I have to run many sql scripts each day. Sometimes I'll have 100+ scripts to run. The scripts always come in a folder numbered in the order they need to be run (001 - ScriptA, 002 - ScriptB, etc.). I've been running them all manaully one by one so that I can look for errors in the re...more >>

I am getting this error in the Event Viewer and the clients are unable to connect to the SQL server. What is wrong? PLEASE HELP!! Scott...more >>

I try to use SQL satatment to query data from SQL Server but I don't know why I need to increase 2 into the "intDay". If there no 2 increse the day will display is 3 not 5. Who can tell me what problems have. Thanks! ================================================= Public Function SetSQLString(...more >>

Hello everybody, one of our users gets an error message when trying to connect to our SQL Server database: 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 S...more >>

Hello there, I have a VB6 application that runs over a SQL Server 2000 Database. Sometimes (most recently) i get the folowing error: Run-time error -2147467259 (80004005) Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447 Expression: m_SizeRec > 0 && m_SizeRec ...more >>

Is there a way to connect SQL Query or Enterprise Mgr through a SSH tunnel. A remote user wants to do querys on a SQL2000 Server that resides at a remote Data Center. We don't want to do a full VPN, as the VPN server that is installed would open the user to the entire LAN. Thanks ...more >>

Hello, I am desperatly trying to export a table from my sql server. Using bcp I only have my csv file with . as decimal for all numbers (I also tried the export wizard of the sql console). Is there a way to obtain these figures with a comma , as decimal? The ddl of the table is below and numb...more >>

I am attempting to connect SQL to a SQL page. I get the following error: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'SQLSERVER2\IUSR_SQLSERVER2'. /felice/index1.asp, line 18 The connect string works fine on my desktop as *.udl file. Any ideas? ...more >>

Is it generally true that local named pipes are better than TCP/IP? Are there any drawbacks? Regards, Per. ...more >>

I have Sybase 12.5.2 Database running in another domain. I am currently working in a different domain under SQL 2000. I need to call a stored procedure in Sybase by passing some input parameters and expect some outptu parameters. How to call a stored procedure in Sybase 12.5.2 from SQL 200...more >>

If you have one domain of application servers running win2000 and seperate user domains with no trust relationships accessing sql databases on the application domain what needs to be done rights wise and is this possible without connectivity issues. Currently these servers are standalone not ...more >>

Hello, I need to retrieve a value from linked server (oracle) and store it into a local variable of a stored procedure . The only solution that I have found is to use a tempTable (the query is parametrized so I need to create a string variable with the full query): ---------------------...more >>

Hi all. I join those who have installed sp2 and have lost the ability to communicate with sql server over port 1433. I have read all of the posts at this forum and have tried all of the fixes recommended. Microsoft's publication (841521) about running firewall.cpl and allowing sql server to ...more >>

Hi, I am getting Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] when try to run a RPC call from one sql server 2000 to an other sql 2000. I have setup/configure the remote server connection on both servers and they have the same sa ...more >>

Hi all! I have a SQL Server from which I need to query a view in a Oracle database. I have created a linked server connection to the Oracle machine. Oracle, version 9i, is running on Unix. Now when I try to use the linked server connection I have some problems. When I expand the linked server...more >>

Greetings ! We're surprise to see no reply to our original question about Object/Relational mappers. So no one as such architecture? We need this for our software since we made such a layer years ago but it doesn't perform as we expected. We're then looking for a commer...more >>

Is there a system table within SQL Server that will display information about the current connections made to the db? IE, username, IP they are connecting from, application they are connecting with, etc? Thanks in advance, - D *****************************************************************...more >>

Randomly, when trying to authenticate to a SQL server, whether via a mmc connection, or via a SQL Query Analyzer, several DBAs / analysts get the following error: "Unable to connect to server <servername>: Server: Msg 11, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Genera...more >>

My SQL*Server 7 server was working fine this morning... All of a sudden anyone that is set up using DHCP to get IP Settings can't connect to any databases... If I change them to a static IP Address it works fine... Can't remember the exact message but it was something along the lines of ...more >>

Greetings; We're looking at O/R mapping technologies for being used between our C++ application and SQL Server. We're developping on VC6. We're currently looking at what the following product may offer: "Versant Open Access" Any suggestions ? Other ORM ? Thanks ! ___________________...more >>

Hi, (Sorry for the over-zealous cross posting - not sure which one to post to.) I need to get SQL server to receive certain mail and process it directly. If I go to SQL Mail in EM, properties it asks for a profile name to test, but there's none their. The server is question has a mail prof...more >>

Hi there, I have to transfer an existing SQL-Server with all his databases and users, to an new Server with Windows 2003. The new mashine has get the same computername and ip-adress as the previous mashine, so that the client pc's, wich access to the server with ODBC, after the switching, c...more >>

Hi All, I have a SQL Server Personal Edition installed in a PC running Windows XP Prof. I can be accessed using Query Analyzer perfectly using SQL Server authentication. However, I am unable to access it from another computer using Query Analyzer. That computer also runs Windows XP Prof. Th...more >>

I need to create a system DSN SQL connection (Data Source) on my machine to a server that is a domain controller in a different domain in preparation for a C# program I'm writing. It is running NT 4.0 server with SQL 6.5 SP6. I have an account on that domain but I can't get authenticated even ...more >>

I used the following syntax and was able to add a linked server to an Informix database. EXEC sp_addlinkedserver @server = 'Server1', -- defined in -- SetNet32 on tab 'Server information', -- field 'Informix Server' @provider = 'MSDASQL', -- DO NOT CHANGE ! @datasrc = 'jaco', -- name of the...more >>

A new instance has been setup on one of our pilot servers. I do not have the sa password to that instance, and it appears that the group who set up the instance also removed the built-in/admin group. Am I doomed to never access this instance? Should I bring flowers, donoughts AND cookies ...more >>

sp_helprotect is used to get all the permissions of including sysobjects.I want to get all user permissions of different user defined objects ----- Original Message ----- From: "Developersdex" <newsgroups@developersdex.com> To: "chandravathi" <tester@us2guntur.com> Sent: Wednesday, November ...more >>

First is can I use Windows XP with the client tools (Enterprise Manager) to connect to MS SQL Server 2000? If so, can someone explaine? I have tried using SQL Server Authentication but I get an error saying server does not exit or access denied. I tried using the SA account and that does no...more >>

Greetings, Our company uses Great Plains 6.0 for accounting purposes. The application uses SQL 2000 as its back-end database. I would like to know if there is any way to prevent odbc connections directly to the tables in. I think the application may be using an odbc connection as well too. ...more >>

Hi all, I'm wondering how to detect and close all concurent connection to a database in SQL Server 2000. Could anyone give me a solution, plz? Thanks! ...more >>

...more >>