Hi, I'm having troubles brining up details of existing SQL Jobs from remote server. When I double-click existing job, it brings up "New Job" dialog box instead of job details. I needed to see and modify steps of a job on my collegue's machine. I can connect to her SQL Server 2005 all rig...more >>

Hello all, My company is running an application that uses sql server 2000 sp3. Sql server 2000 is configured to accept only TCP/IP (port 1433) or Named Pipes. We prefer to use TCP/IP but we are having issues with users losing there connection to the DB if they use TCP/IP. The problem is spora...more >>

Hi, I can't connect to my remote SQL Server 2005 Express - can anyone help? SETTINGS: Server Type: Database Engine Server Name: {my remote IP} Authentication: SQL Authentication User Name: {my Username} Password: {my Password} ERROR: Error: Testing the registered server failed. Verify ...more >>

Dear recipient: How connect from sqlserver 2000 and 2005 to essbase??? Is with ODBC or OLEDB or I dont have idea? Can you help me please? Thanks for your atentions. Regards....more >>

Visual Studio MS SQL Server i have this connection string... Data Source=.\SQLEXPRESS;Initial Catalog=dbName;Integrated Security=SSPI; but an error appears on my conn.Open(); Cannot open database "dbName" requested by the login. The login failed. Login failed for user 'SERVER\yshie'. y...more >>

What is the best way to do this? Specifically, the Memberhsip class database. Maybe that's more of my problem than just copying a database, is that my database also contains the membership tables, which I really can't lose as th 40+ users in it would be gone. What's the best solution? is it ...more >>

Hello, I have one SQL Server 2000 that has been installed into a domain, having allowed "Windows and SQL Server" authentication and using as connectivity options Named Pipes and TCP/ip - 1433 On every client computer that is also a domain member I can set up without any prob...more >>

I am running SQL Server 2000 sp4 in local mode on my laptop. I have some other software which uses 1433 to access SQL. Remember this is all running locally on a laptop. Port 1433 is being blocked. I have both the Windows Firewall and the Mcaffee Firewalls disabled. How can I find out wh...more >>

Hi, I want to create a login (for account ASPNET from the Active Directory) in sql server express 2005 for a specific database. When addidng a new user to a specific database, i see: Owned schemas, where i take db_datareader and db_datawriter Roles memmbers: also db_datareader and db_datawrit...more >>

We have a production database and a test database on different servers, but with the same name, and we want our programs to be able to tell which is which, so we created a table in Master on the production server only. It oughta be really easy to query for this table and know if you're on tes...more >>

hi i need to connect a small program written in Python to a SqlServer 2005 database how con i do it ? can anyone link me to a resource ? thanks ...more >>

Hi All, I am getting the following error in the ERRORLOG File when I am trying to connect to SQL Server 2005 Express Edition from the command line. 2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State: 16. 2007-03-23 07:30:05.54 Logon Login failed for user 'sa'. [CLIE...more >>

Hi, i have already posted this problem in an ASP newsgroup without succes, so i try here. I try to access within an cliassic ASP page an MDF file (newres.mdf) of sql server express 2005 database which is located in c:\inetpub\wwwroot\reskrosql\App_Data. I get following error : Provid...more >>

Hi, I try to make a connection with the database "test" contained in sql server express 2005. This is the connection string in the aspx file: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=SQLOLEDB;Data Source=laptop\sqlexpress;Integrated Security=S...more >>

Hi, I am remotely accessing SQL Server 2005 using an import manager, through a windows authentication login. I start the loading, it connects perfectly at first but at the 100 second mark I get the error "[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or acces...more >>

Hi, My sql 2000 server is connecting to as400 using IBM odbc. How can I access to data of various member of a file db2/as400? What is the syntax of sql scripts? Thx, Michelle....more >>

Hi, We have a 64bit SQL Server 16GB Memory running on Windows 2003 x64. This is one of our main business database servers. At this time we have an issue where the server will stop allowing new connections in, the client will receive a timeout (instantly) and from .NET the stack is at ...more >>

Hi When i try to start the SQLAGENT on my SQL SERVER 2005 it notify me that the SQLAGENT Started and Stopped becuase he dont any work to do, i tried to stop the sql server service and then start the agent. what happend is that the agent service started the sql server service and then started h...more >>

Hi All, I have two servers with the following detail: Server #1 Server Name: SQL2005WIN2003SERVER Windows: Win 2003 Server SQL DB: SQL Server 2005 ('sa', 'pswd123') MS.NET: .NET Framework 1.1 and 2.0 Firewall: NO Server #2 Server Name: OLDMSDE\WIN2000SERVER Windows: Win 2000 Server ...more >>

hi * I have some program, written in C, that uses ODBC API to connect to MSSQL Server 2000/2005. To create a connection with server I use SQLDriverConnect function with such connection string: "DRIVER={SQL Server};SERVER=MY_SERVER;Trusted_Connection={Yes};DATABASE=MY_DB;" How can I creat...more >>

I am receiving this error while trying to connect to a SQL Server 2005 instance. "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote...more >>

We installed long horn server build 6001 and then we enabled IISv7.0.Subsquently We installed SQL Server 2005 enterprise edition (EvAl) After installation is completed all the SQl related services are up and running. When we are connecting to SQL data base we unable to login to the system....more >>

Hi, I'm using SQL server 2005 Express Edition in my solution and I've run into a problem that I can't find any information about. The application was running OK (for several days) until this happend just out of the blue. The application is written in C++ and we are using ADO to access the d...more >>

Hi, I have Sql Server 2005 Std edition installed on a Windows 2003 server and the client components installed on my machine with Win XP. The Surface area configuration was configured on the server to allow TCP/IP and named pipes. My network login has been added to a group that has been ...more >>

I migrated copies of a database to a test server, but I cannot log on. My admin account needs to be dropped and readded but every time I run sp_dropuser in query analyzer I get the error : Msg 15183, level 16, state 1, .... "the user owns objects in the database and cannot be dropped." then ...more >>

I work in a domain environment with a couple of Enterprise Edition SQL Servers. Using SSMS, when I go to register a new installation and I 'Browse for more' in the dialog box, I see a whole bunch of workstations that I know are set up with MSDE. How do I keep these machines from broadcasti...more >>

Hi All, I am an VC++ programmer. I had written an VC++ application, which will fetch data from SQL Server. I am doing DB Connectivity by creating a DSN. My application works perfectly. But it lacked with need some performance issues when the DB Connectvity fails. ...more >>

Hello, i'm looking after the possibility of importing / exporting data from / to Excel and Access. Thanks for help Casper ...more >>

Hello, i'm looking after an equivalent T-sql command as "load data local infile ...." of Mysql, in order to import a textfile into sql server express 2005 containing data and delimited with tabs. Thanks Casper ...more >>

Hi all, We had to rename the hostname of a server where SQL 2005 and Analysis services were installed. SQL 2005 picked up the change no problem, but when we try to connect to the Analysis services side of things, it's still connecting to the old host name. I've been digging around and seen ...more >>

I receive Error 340: General Error when I try to open MSSQL7, Enterprise Manager. Can someone help Please?...more >>

Dear All, I installed the SQL Server Express 2005 + SP2 on Windows XP x64 +SP2, the TCP/IP, Named Pipes and SQL Browser services are enabled, and client computer runns under Windows 2000 with Native Client driver installed. I can connect the instance with ADO or Native Client within the same...more >>

Hi everyone, I'm quite new to SQL Server so maybe this is an easy question but I haven't found the answer after 3+ hours of Googling and experimenting. I have a simple set up - two computers named HELEN and DELORES, both running Win XP Pro, SP2. These machines are connected via a home netw...more >>

May you help for beginner. I have installed MS SQL server 2005 to local computer. I can not connect to Server type "Analysis Services" from Management studio. Message "A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)" appears. But I...more >>

I HAVE SQL2005 32 BIT ( TEST) AND SECOND MACHINE 64 BIt (PRODUCTION). IN 32 BIT I LINKED SUCCESFULL DBASE FOLDER (FILES CLIPPER) BY OPENROWSET BY: select * from OPENROWSET('MSDASQL', 'Driver={Microsoft dBase Driver};SourceDB=c:\MyApp\;SourceType=dbf', 'select * from MyTable') --------...more >>

I have a server running SQL Server 2005 Ent. Ed. SP2 and locally, I can see the default instance and two SQLExpress instances named 'sqlexpress' and 'officeservers', all withing SSMS, and can connect and manage them. From my workstation, running SQL 2005 Dev, SP2, I can connect to the default...more >>

I have a SQL Server 2005 Express db on my local machine for testing and I'm using Dreamweaver 8 to connect to it. No problem. However.. when I try out a page on localhost through a browser, I get this message: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Se...more >>

i am trying to update linked SQL Server tables in Access. i don't receive any error messages. i can open the linked table and view the data, but i cannot update the info. i can update in SQL Server and view the new info in Access. any ideas? Thanks....more >>

Is there a limit to the number of users that can be connected to a SQL Server 2005 Express instance? If the hardware is beefy enough, could it support 20 or 30 simultaneous connections? TIA -- Todd Chittenden...more >>

Hi We've installed SQL Server 2005 Express on a Windows XP SP2 machine that will serve as the server. The configuration is fine and we've enabled all the protocols. The client computers are mostly Windows 2000 and one Windows XP machine. They connect to the SQL Server via a VB6 applicat...more >>

I tried to setup a link from Win03; Sql 05sp1 64 bit (ProLiant dl385 AMD) to Oracle and I get an error. EXEC sp_addlinkedserver 'orp5', 'Oracle', 'MSDAORA', 'orp5' EXEC sp_addlinkedsrvlogin 'orp5', false,null, 'username', 'password' SELECT * FROM orp5..XXSA.XXSA_OID Msg 7403, Lev...more >>

Hi, I have a problem using an jet database as a linked server. when there is no database password on the mdb database everything is working fine. When I put a password an the mdb database I receive the error: Msg 7399, Level 16, State 1, Line 1The OLE DB provider "MSDASQL" for linked server ...more >>

Is the option OLE DB Services = -4 still valid in the connection string with the SQL Native Client ? ...more >>

Bonjour, Voil=E0 , j'ai install=E9 une instance SQL server 2005 SP2 sur un serveur windows 2003 SP1. Lorsque je lance le surface Area manager pour configurer mon instance, j'ai besoin d'activer xp_cmdshell, j'ai le message d'erreur ci dessous : =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3...more >>

I have recently changed my application from using SQLOLEDB to SQLNCLI. Occasionally I'm seeing an error "SMux Provider: Physical Connection is not usable" What does this mean and where does it come from ? Thanks. ...more >>

Hello all. I have one laptop and one workstation. Both are running: - Windows XP Professional SP2 - Microsoft SQL Server 2005 SP2 (SQLServer2005SP2-KB921896-x86-ENU) - No Domain. Workgroup configuration. Same username and password on both systems. - Each SQL instance is named. - TCP ...more >>

(newbie here) I'm unable to create a DSN to connect to my instance of SQL Server 2005 running on my Domain Server (Windows Srv 2003). I'm running the Developer edition. I can create a DSN on the server itself (so local connections work) but cannot from another machine on the LAN (Windows ...more >>

I have in my company a server with SQL Server. how do i connect to my server (using a vb6 application made by me) from my home??? thanks for any help ...more >>

Hi, When I try to login to SQL Server 2005 from Microsoft SQL Server Management Studio, I got following: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other ...more >>

We have just installed SQL server on a Win 2003 server. We are getting the following error message when we try to use it from the 2003 machine. A connection was successfully established with the server, but then an error occurred during the login process. (Provider: Named Pipes. Provider error ...more >>