Hi, on a very popular slide with new features of SQL Server 2005, I saw "VIA Support" as a new key feature for the SQL Server Engine. But I do not get what that is. I read that this is the protocoll that SANs use, and also is the API that SANs use. Firstly I presumed the new "VIS support" mi...more >>

I just started today at this company. They have a 2003 SQL server here in Dallas and twice a day it updates with the main SQL server in NY. And I don't know that much about it. When I look at the SQL Server network connections..there is only one connection..the LAN connection..however when ...more >>

I have an application that needs to to talk to MS SQL Server 2000. When I connect from a client machine, I am getting db-library network communications layer not loaded. What component is it missing? -- Cathy B...more >>

I've just built our new 2005 cluster and I'm having some issues with connectivity via a client network alias. It's a 2 node active/active 64 bit Ent Edit, sp1, 32gb ram. Both nodes are listening on port 1433 with both tcp and named pipes (although we never use named pipes) Node Names are: ...more >>

I installed SQL Server on my PC and it has been running fine for a few months. Now I cannot start it but get this message: ------------------------------------------------------------------------------------------- An error 1059 - (The Service did not Start due to a logon failure) occurred ...more >>

I am new to the linked server concept and I'm having trouble with the following scenario: Users are trying to run a report from Reporting Services whose data is supplied from a stored procedure. The stored procedure gets its records from 2 sources. One is a regular SQL Server table. The other ...more >>

Hello, A User currently having a problem with an Access 2000 application that uses Linked tables to connect to an SQL 2005 database. The user receives the following message: Connection failed: SQLState: ‘01000’ SQL Server Error: 11004 [Microsoft ][ODBC SQL Server Driver][TCP/IP Sock...more >>

I am using MS SQL Server 2003 in a server running Windows Server 2003. Workstations with Windows 98 Second Edition cannot connect through TCP/IP ODBC link, workstations with Windows 2000 and Windows XP can do so. What can I do? Is it possible to connect MS SQL with those types of OS ? Some l...more >>

Hi, one of our customers had a server crash. So I recovered the database from backup and integrated it successfully into another sql server. I'm able to connect through DSN file. Tests ok but the application which should work with the database seems to have problems to read or connect to th...more >>

Hi, My old MSDE machine died (powersurge). I bought a new dell with XP home on it. I downloaded SQLEXPRESS. I have enabled TCP/IP and named pipes. I have uninstalled the firewall software on the PC. The router (2Wire) has port 1433 and 1434 open. I previously connected two ways - ...more >>

I have a local server I just upgraded to 2005. Everything went well. But, I also have a remote sql 2000 server I still need to connect to. Can't seem to get the tcp/ip connection to old server to work. Go back to old 2000 tool and it works fine, but I'd prefer to stay in one environment a...more >>

I am having problem connecting to a database using EM or Query analyzer. Both applications start up fine. When I click on the database folder to expand it in EM or the drop down in Query Analyzer, both applications hangs and nothing happens. The SQL services started fine. Please help. Emma ...more >>

If I understand correctly, Enterprise manager has been replaced with SQL Server 2005 Express? Can I use SQL Server 2005 Express from my desktop to connect to an SQL 2000 database on the internet? Thanks, Vic ...more >>

Dear all, I've installed SQL2005 on my local machine. And there is another SERVER = which has install both SQL2000 and SQL2005. I can use my local = Management Studio to register the SERVER\SQL2000 instance but I cannot = register SERVER\SQL2005 instance. How can I register and connect to t...more >>

I Have SQL Server 2000 local installed on a Windows XP SP2 machine, Dutch version. SQL Server first connected fine via the default settings 'Use Windows Authentication'. I use it to test VB.Net practices, which went fine for a while. I am busy preparing for the 70-310 exam. Then I had proble...more >>

In order to stop some occasional blocking issues could I set the "query execution time-out settings" to 30 seconds for example. I understand it will kill the queries that exceed 30 seconds, but I would rather have that then to have everyone "lockup". I also understand that blocking is caused b...more >>

We are still having issues running maintenance plans on a server since joining a large domain. Error message for the backup job follows: The job failed. Unable to determine if the owner (DomainName\sa-stpisap) of job DB Backup Job for DB Maintenance Plan 'DailyMaintenancePlan' has server ...more >>

I was given this one. Right now I am familiar with how to do this in Access, but SQL Server is what I need to use. What does one have to do to connect SQL Server (right now 2000, but soon 2005) to a FoxPro free-table directory? I would like to have this be a READ-ONLY data source as I do n...more >>

On my development maching, I have three different SQL Server instances: ..\SQL2000 ..\SQL2005EXPRESS ..\SQL2005 When i try to debug a stored procedure in Query Analyzer, I get the following error: "Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL S...more >>

I am attempting to attach an .mdf to SQL Express using "AttachDBFilename" in the connection string, and I have a few questions on the issue. I am planning on setting this up on a network with both the .mdf and the instance of SQL Server residing on a server. All the clients will be running ...more >>

How can I change the Connection String programmatically? (WS2005, Windows forms, C#) I need to change the server name, or Initial Catalog parts of the string. My connection strings are in a field of a master SQL database table. The design of the different databases are the same. How can I pas...more >>

I am using a 2003 book by Dan Maharry called "Beginning VB .NET 1.1 Databases: from Novice to Pofessional" ISBN 1-59059-358-8. I'm simply trying to view my MS-Access database tables and stored procedures from my Visual Studio .NET 2003 Standard Edition (VB). I downloaded the file: MSDE2000A.e...more >>

hi until today, with sql2000 i get recordsets connecting with "Provider=sqloledb;Data Source=myServer;Initial Catalog=myDB;Integrated Security=SSPI" but now, having migrated to sql2005 i use "Provider=SQLNCLI;Server=myServer; Database=myDB;UID=xx;PWD=yy" i...more >>

Hi Folk Can you tell me how I can connect to an SQL server using a vbscript? Basically, I want to do the following: ...define array of sql statements (e.g. select * from customers, selec...) ...connect to databsae ...run sql statements to extract files ...ftp extracted files (csv) to webs...more >>

Hello I need to create two DSN's on one machine, both pointing to different SQL Databases (but housed on the same remote server). One runs on the standard 1433 port and the other on port 1075. I have both of these setup, but I cannot use a different port in both. If I set it to 1433 in DSN ...more >>

[WinXP Pro SP2, SQL Server 2000 SP4, VS C++ 2005 Express] A humble hello to all, I have spent days trying to simply connect to an instance of SQL Server 2000 SP4 from a program written in C++/CLI using VS C++ 2005 Express. I originally had SQL server 2000 Dev Ed and SQL Server 2005 Express...more >>

Hi All, I have this weird problem and hope someone can help me. I have a SQL Express 2005 installed in a WIndows 2000 server. After the initial installation, I can login into the SQL server using the SQL 2005 console. However suddenly, I no longer can login either using SA or Windows Authen...more >>

hi everybody! can anyone help me, please. thanks in advance. i have installed sql server express 2005, and have a .mdb database in access 2003. with the upsizing wizard i have succeeded in connecting to a sql database. i am now trying manually to connect to sql server, bu t i cant seem to fin...more >>

username: Jeff.Mitcham password:Abc1234 IP of the server is 202.138.138.73 Thanks, Michael PS. You can mess around with whatever you want....more >>

Hello everybody, " PuAdoConnection As ADODB.Connection .... Set PuAdoConnection = New ADODB.Connection PuAdoConnection.Open "Provider=sqloledb.1;Data Source=xxx;Initial Catalog=xxx;user id=sa;pwd=xxx;" " On "Open", error 3706 "Impossible to find the supplier. It is perhaps badly insta...more >>

hi, I can't connect to a server that's running on my machine. I can't even connect to it through Enterprise Manager. Im in big trouble. Can somebody help? I think this is happening because I had granted access to another database for a new login/pwd. Now I can't even get my server regi...more >>

hi, I recently added a new login/pwd for a database I couldnt connect through my asp application. Now I can, which is nice. But, now I can't connect to other databases. I have an adp project and when I try to pull it up, I get the message that there's a problem connecting. I do get it , but...more >>

I have 2 NIC's on the SQL servers. Once I enable the 2nd NIC on a seperate network, the SQL admin's can not connect to the SQL databases via Enterprise Manager. I have checked the do not propagate/create a DNS entry, but the server is a DNS server. Any ideas?...more >>

Hi All, Not sure where to put this post, hope this is the right place. Relatively new to SQL, not sure what info you need, so here we go: We have a Windows 2000 Server running SQL 2000 ("Server1) in location 1. This server is outside of the firewall. We have a network setup in location ...more >>

We had a problem in the past where changing from TCP/IP to Named Pipes fixed a SQL Connection timeout that happened every so often. Well, now we seperated the Web server and SQL Server onto our new Dell Blade systems which are pretty fast (faster than what it used to be on). However, I can...more >>

Hello , I'm trying to create an application, which would say if sql server is running on a machine. Hope i can get this from windows registry. Is there any other way do achieve this programatically through windows SDK , or checking the services programatically ? If i need to check the regi...more >>

Hi group, I'll briefly explain the situation. I installed a new SQL Server 2000 SP4 on a windows 2003 SP1 server and I have a database in a named instance running. The client where I installed this server has 2 networks, one is local and only has a couple of workgroups, the other one however ...more >>

We are in the process of migrating the application that runs our business from Sybase ASE 12.5.3 to MS SQL Server 2005 SP x64 Our application is a large java application which runs on Redhat Enterprise Linux 4, Tomcat, etc. We have written a standalone java console application to test the ...more >>

I have just upsized my backend mdb file. It has created the new SQL server database, added the linked tables in the old mdb file and changed old tables to "oldname-local". All as expected. I can double click on either the old or new linked tables in the backend mdb file and see the data. Ho...more >>

hello i have to merge data to sql server via gprs in my application developed in vb 6.0. can any one help me how can i send data to sl server via gprs Thx a lot ...more >>

Hi, I have database, I created a db_owner and linked it to an AD Domain = user. But I cannot connect from my C# program. It fails to login every time. I've tried with connectstring: .. uid=3DMyDOM\MyUser.. and .. uid=3DMyDOM\\MyUser..=20 everytime the connection fails. Also,...more >>

What's the best group in which to ask about DTC issues? ...more >>

I am trying to connect to a MSDE instance across the internet. I installed it at my house and can connect from work no problem. Installed it at a customers and I can not connect to it. I can access their Linksys router and have the correct ports forwarded (I tried setting the DMZ on, it m...more >>