Hi.. I try to connect sql server. I have installed a sql server 1. SELFPACEDSQL 2. an instance with name MyNamedInstance I am trying to follow the sertification book page number: 95 Chapter 3. figur 3,11 I got this message when I try to execute following commands: C:\Documents and Setti...more >>

We recently moved to a sql 2000 cluster. An application uses named pipes odbc connection to connect to sql server. It cannot use tcp/ip. When trying to connect to the new cluster, the odbc connection test is successful (and verified it is using named pipes). Yet when this application (actually...more >>

Hi all i need to know if sql dmo can connect to SQL server 2005 if can! how can i do this ?? i have this code Dim xServer a SQLDMO.Server ......bla..bla... xServer.LoginSecure = True xServer.Connect("SQLServer2005") but it can´t connect. is there anyother way ?? thks JSB ...more >>

Okay, this is a really simple question. This for xml explicit query --- SELECT 1 as Tag, NULL as Parent, G.GrandParentID as [GrandParent!1!GrandParentID], NULL as [Son!2!SonName] FROM GrandParent G WHERE G.GrandParentID IN (Select GrandParentID from Son...more >>

Hi there I'm using SQL Server 2000. I often use the UPDATE ... SET ... statements to change data in my database, affecting up to 3 million rows of data. If I issue the statements from Enterprise Manager I get a "timeout expired" error on large queries, whereas if I execute the queries from ...more >>

Hello -- we have SQL Servers running in a Service Bureau environment. How clients frequently use applications at their sites to access our SQL Server. Unfortunately, some of our clients are more sophisticated than others and know about Enterprise Manager and Query Analyzer, which they can try...more >>

There is a Remote SQL server 2000 server that can connect (registe thru query analyzer or enterprise manager) with 3 remote Sql serve 2000 servers without issue. When these 3 servers try and connect bac (thru query analyzer or enterprise manager) I get the "SQL Server doe not exist or access den...more >>

Hi all, I have the following problem. I know that MSSQL resides under given IP adress but I do not know under which port. Who konows how to determine this port number? Best wihses, Marek Powichrowski ...more >>

Hi All, I have a Windows 2000 machine running sql server 2000 at office. Recently, my sql server has become painfully slow. To give an idea, entering Query Analyzer takes 1 min just to establish a connection with the database. Choosing a database from the drop down takes a long time...more >>

I am trying to set up a linked server to our iseries through Enterprise Manager and am getting the message; Error 7304; Could not create new session on OLE DB Provider 'IBMDA400' OLE DB error trace [OLD/DB provider 'IBMDA400' IDBCreatesession:: returned 0x80040e44]. I am using the follo...more >>

We have an Access 2000 front end running on XP boxes connected to an SQL 2000 standard edition install on 2003 Server via ODBC. After about 10 or 20 mins or if the box is idle for awhile it cannot connect to the SQL server or it dies in the middle of working through the frontend. I get this: ...more >>

We are having some slow connections to our sql server. The server is located at Site A, everyone at Site A can connect to the server through the LAN quickly, just the way things should be. People at Site B, however, connect to the SQL Server at Site A over a WAN; this causes the connection t...more >>

Thanks in advance for any help. I really appreciate it. I am getting a strange error message when connecting to a single Sql Server all of the sudden. From enterprise manager the error is: A connection could not be established to ServerName. Reason: Communication link failure Please ...more >>

I have 2 SQL Server on remote Network. ServerA and ServerB, There are firewalls between them. However, the ServerA could regist ServerB via Enterprise Manager, but the ServerB could not regist ServerA via EnterPrise Manager.... Both are sitting ON Windows 2003 Server, and 2 Servers Could regis...more >>

I have 2 SQL Server on remote Network. ServerA and ServerB, There are firewalls between them. However, the ServerA could regist ServerB via Enterprise Manager, but the ServerB could not regist ServerA via EnterPrise Manager.... Both are sitting ON Windows 2003 Server, and 2 Servers Could regis...more >>

Which version of SQL 2000 can I run log shipping on? Thanks ...more >>

Just installed SQL Server 2000. However when I ty to start it gives me the error message: The sevice did no start due to a log on failure. "An error 1069 occured while performing this service operation on the MSSQLServer service." I am running XP Pro with SP2 installed. Need some help please. ...more >>

Hello, I am getting the following errors when I try to connect to SQL from a XP workstation: Connection Failed. SQL State '01000' SQL Server Error:10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen(COnnect()). Connection Failed. SQL State '08001' SQL Server Error...more >>

I am using Analysis Services and SQL 2000. On my Analysis Services machine I define my data source to point to a remote SQL 2000 server using windows authentication with my domain admin account. I can create the cube and everything looks great but when I process the cube I get login errors. d...more >>

Hi there I'm not a SQL Server developer or power-user, mostly I do statistical and similar analysis on large datasets and use SQL Server to manage the underlying data. I notice that, on my IBM workstation, my CPU utilization doesn't rise much above 50% and my PF usage doesn't rise above ...more >>

Hi guys, I need to know whether SQLDMO.NameList returns only SQL Server instance names, or whether it returns ALL server instances in the domain (including Oracle). I'm doing a project for a government department (an Oracle shop). I have been building a system that backends to SQL Server...more >>

hi, does any body know, how to send email through SQL server. any setups(out look express etc.) needed for this. any code for this? please let me know, if any body knows. thanks. hari...more >>

Hi, I'm getting a session timeout from time to time whilst working on a web application that I have on my machine. Is there a way to extend or disable the connection timeout? Would it be done from the IIS manager or from within the global.asa file, or both? In IISA Manager I've tried set...more >>

If anyone knows the answer to this I’d me greatly appreciative. I am not on a domain. I have SQL Server sitting on computer A Computer A has: Windows XP SP2 SQL Server 2000 SP3a SQL Server is set to use Trusted or SQL authorization I have added a user X to SQL Server with a passwo...more >>

Hi there I'm using the .NET Framework 2.0.40903 ... I had some interoperability issues between SQL Express and the Framework 2.0.40607, so I'm reluctant to do anything drastic with 2.0.50215. Has anyone taken the plunge? Best regards Loane ...more >>

Warning beginner here. I posted this in the setup news group but haven't received and replies, so perphaps someone here can help me. I am developing a small ASP.NET web application that will use an SQL Server 2000 database. The database will start with 1,000 records in a main table and ...more >>

I am not able to start the MSSQL Server service on my system ever since I shifted my house and got a new network provider. Earlier, I was on the local cable hub, now my computer is on a DSL network. I don't know if the network would have something to do with it, but I am just providing informati...more >>

I am having difficulty registering to a newly installed server. The server resides in a remote location. The server is using mixed mode. I set a user up on the server named SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL with the same rights. Whe I attempt to re...more >>

Hi I am a newbie so I will try to describe my situation below. I purchased a Server running Windows 2003 and installed SQL 2000 with SP4. The server is hosted in a co-location building at my ISP. I have terminal Server access. I have a application that I will use to connect thru the interent t...more >>

Dear All; I use Access 2003 with Sql Server 2000. While i edit data at client, sql server downs. So when i click Save, error message appears. How to reconnect, when sql server restart? Thanks ...more >>

i am trying to connect to sql server in a remote database by using windows authentication. I tried to connect using php and cgi. The apache service under which i am running my cgi or php is under localsystem account. If i change it to administrator account, i am able to connect to remote sql s...more >>

what is the syntax the server alias and the server name? Is this correct: server alias should be the "computer-name\sql-instance-name"? Will it work against a default instance? server name should be the "ip-address\instance name"? ...more >>

I got this message when running the same project at my work which I worked on at home without encountering it. Thanks for the help. Request for the permission of type System.Data.SqlClienAdditional information: Request for the permission of type System.Data.SqlClient.SqlClientPermission, S...more >>

Hello, sql server 2000 cluster patched to SP3 and NT5 patched to SP4. Oracle 9i client installed. We have set up a linked server to an Oracle instance using the 'Microsoft OLE DB Provider for Oracle', this works for a while without any problems and then for an unknown reason ceases to work....more >>

When i try to connect through dial up to sql server 2000 running on Windows Server 2003, i get the following error message: Run-time error '-2147467259 (80004005)': [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I am using VB6 running on Windows XP....more >>

Hi, I am trying to find out how to connect to a database, inside a stored procedure...including identification (Username and passsword)? I tried the CONNECT TO statement, but when I try to use it, I get the error: [ODBC SQL Server Driver]Syntax Error or Access violation I am using the ...more >>

Hi there I receive a very much unstructured flat file, which I import into a SQL Server database using DTS. After the import, one of the flat file columns is in the format char(6) rather than datetime. The problem seems to be that the text file column is in the format 'ddmmyy'. When I use t...more >>

I'm using ado to connect to a sql server 2000, and suddendly the line that does the connection (conx.open) is taking a long time. All the apps that connecto to the server take a long time also. Additionally, when you use the sql manager, when you retrieve the rows from a table it takes a long ...more >>

Hi, After an install of visual stiudo team 2005 beta 2 I can no longer connect to any SQL Server in my enterprise manager (But showes SQL Server running) and I get a connection error when I try to edit an SP from query analyzer. this is the error I see in both places. [Microsoft][ODBC Driver...more >>

Hi, I have a problem to find out every NtUserName in my SP that take information from Sysprocesses. Some NtUserName columns ary empty and I have much hard work to discover who's that guy connect in my Database. I think to match another utility throught xp_cmdshell to run an get NtUserName by ...more >>

I have a Dell 2850 that is being setup for a SQL database. In the past (for example my Exchange 2003 server) I have had problems when teaming the NIC cards on the server in a load balancing mode. My question is, for SQL server (this server will also run IIS) where clients will connect via ...more >>

We have a program using sqlserver7, bde 5.01, msde, which works fine on the 98se machines we have connecting to ntserver4, however we got a new xp pro machine with sp2, I have mapped the exe to the network and it goes to a login screen, where it then fails to connect to the database with a gen...more >>

Hi All, I have an intriguing problem and I wanted to see if somebody could help me. ENVIRONMENT: Server Side: 2 identical Windows servers 2000 with SQL Server 2000 Enterprise Edition SP3a Client Side: workstation with Windows 2000 PRO Protocols enabled in the server and client: TCP/IP a...more >>

Ok, I can connect to the sql server instances using tcp:ServerName,PortNumber. However; I still cannot connect using ServerName\InstanceName. This would not be a big deal, if I could get Enterprise Manager on a remote machine to register the instance using the tcp:ServerName,PortNumber for...more >>

Hi there I'm running a DTS package that imports data from various Excel spreadsheets into a SQL Server database. Running the package from the command prompt, I get information on each data pump task including each 1,000 rows imported successfully. When all rows have been imported from a par...more >>

Hello. I have recently installed a second PC and it is connected via a LAN. I have SQL Server 2000 installed on my main PC but I wanted to access the SQL databases in the server from the other PC. Main PC running XP Pro, other PC running 98SE. I have installed the client tools on the 98SE but am ...more >>