I'm using VS2005 pro to develop one windows form and one Mobile5.0 app , they are simple apps and just connect to SQL server to get data. The SQL servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5 Express. All works fine until one day I updated Win2K3 patches to the sql se...more >>

Hi, From my research, it appears that it is not possible to have a linked server created in SQL Server 2005 x64 use a 32-bit DSN (i.e. created with a 32 bit driver). The answer is that I need to create a 64-bit DSN in order to create a linked server in SQL Server 2005 x64. The problem is ...more >>

How do I run a stored procedure from within the Enterprise Manager? Thanks...more >>

We recently installed SQL Server 2005 on machines that also had SQL Server 2000 present. When the SQL Server Browser service is running on any of these machines, ALL machines on our network start having a problem detecting the names of SQLServer instances from SQL Server 2000 applications (Ent...more >>

Hello Did anyone ever get the SQL2000 server or MSDE to work on an XP Pro computer, with a static IP address? If so how is this done? I’ve done the following: 1) setup router to forward to a port 5000 2) I setup MS SQL server to listen to this port, I check error logs, and it is listenin...more >>

I have just installed the SQL Server 2005 Developer edition. SQL Server 2000 is also running. I cannot see the instance of the 2005 installation. Is there anything more I should do? Thanks Yannis ...more >>

Hi, May I know what is the error below? I can't even login with sa id. It fails on two workstations but it works on the rest of the workstation. Connection failed: SQLState: '01000' SQL Server Error: 53 [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()). Conne...more >>

Hi, My database transaction log file grows very fast. I have limited the maximum size at the moment and set the log back up process. Can someone tell me if I can delete the log file and generate the new one once it reaches the maximum size ? What could be the affects if I do so ? Wh...more >>

Hi, I just install SBS 2003 with SQL 2000 on my server, but when I try to use another PC (OS is WinXP) connect the SQL server throgh ODBC, it pop up a error msg: connection failed SQL state '28000' SQL server Error: 18452 Login fail for user 'XXX', reason : Not associated with a trusted SQL ...more >>

Hi, I believe I'm running into a backward compatibility issue with the sqlserver 05 Enterprise edition. I restored a database from sqlserver 2000 to my new sqlserver 2005. Both of my .net project and Access gets time-out errors (running remotely) when they try to access to a table that I h...more >>

How can a non Windows App , say an app that runs on Linux connect to SQL Server using Windows Auth ? Has anyone done that ? How does Linux integrate with Windows ? Are there 3rd party tools ? We know SQL Auth would work but we want to use Windows Auth only. Please let me know Thanks ...more >>

Hi, Has anyone seen this error: A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using report server URL for the Server name, or if the Distributed COM Users group exists on the remote compute...more >>

Hi, My C# app uses SQL Server 2005 Express edition. I store my connection string in a config file. My application will run on numerous machines and therefore the machine name will be different each time. What I would like is a generic connection string so that I don't have to change i...more >>

I'm not sure if this is the best forum to post this in (if not, if somebody can suggest a good forum to post this question, I would appreciate it!) I have a client with an application setup as follows: (1) Web Server running Windows 2003 Standard Edition Server & IIS. (1) Web Server also ru...more >>

For some reason i want to use visual c++ 6.0 , and i need to connect to sql server! (most probably 2005) can this be done? if yes please provide me with a sample on how to connect (e.g. how to create connection, data adapter , data set.... , the whole deal) thank you in advance, i really a...more >>

I copied a project I am working on from one computer to another computer for work at home. I try to access the mdf file that I have for this project, and now it tells me that authentication has failed for my windows authentication on my system. I am trying to find out how I can change the au...more >>

Is there a way to specify the sysprocesses.program_name value in the OLE DB connect string? I can't find the syntax anywhere. Thanks, Tom...more >>

Greetings! We have a connectivity problem between Excel 2003 and SQL Server 2005 AS. We created cubes and it works OK on server. Then we installed Excel 2003 on AS server to check connectivity. It works OK. But on any other workstation with Excel installed it could not connect. It shos the ...more >>

The server I am working on is configured for TCP/IP, Windows Authentication only, the SQLExpress named instance have been configured to use port 1433 and the appropriate changes have been set on the firewall . Q1. Is it possible to remotley connect to SQLExpress 2005 via the internet specifyi...more >>

I am getting time-out errors when I try to perform a simple delete on a linked server. The command is: Delete From MyTable Where PKID=12345 I have tried executing this command directly from Query Analyzer, but it just times out. However, when I run it from QA against the server itself ...more >>

We are using a third party app on Win XP SP 2 machines (3.0 Ghz, 1G RAM) that uses SQL Server 7.0 SP4 as the underlying database engine which is running on Win NT 4.0 SP6. All 8 of these XP machines run extremely slow when we use this app to read and especially when we write to the SQL databa...more >>

Hi, I am using windows server STD 2003, with SP1, with SQL server 2000 with SP1. The database stops working almost every 24 hours. I have to stop/kill services and then start again to get it back up. Kindly advise. Thanks...more >>

I have created a SQL 2005 database with about 100 tables. It was actually mostly created on 2000 and attached. I have started creating a VS VB application. I am able to use any and all the tables in the applications. I have updated individual tables. I have published the appl and have i...more >>

I created a SQL Express database from within Vistual Studio. It had a property ConnectionString, so I grabbed that value and attempted to use it in code. (I did add an @ at the beginning and doubled the literal double quote symbols.) The code that assigns the connection string and opens the...more >>

I am unable to connect to a SQL Server 2005 instance running remotely on a Windows 2003 Server machine behind a router. I can connect to the instance via SQL Server Management Studio Express when I place the server machine in the DMZ, but I cannot connect when I forward traffic on port 1433. Not...more >>

After creating a linked server to a remote server, I needed to log in using sp_addlinkedsrvlogin to get my stored procedure to work. However, I noticed that after stopping SQL Server and the DTC and then restarting both, that my stored procedure worked without having to execute sp_addlinkedsrv...more >>

HI Guys, Got the following scenario: Client machine: Windows XP Pro (SP2), logged in as local user Server machine: Windows XP Pro (SP2), running SQL Server 2000 both machines in same Domain. I am attempting to connect from the client to the server using SQL Server authentication, which i...more >>

dear all i need to upgrade my client's db (the new mdf file has some new stored procedures). since the client has quite some data in the current version (and there is no way i can access the data myself), i thought that, after installing the new files, i'll open the old mdf file, and "select...more >>

I have a network with 6 machines sitting on it. All PC`s are configued in the same way. 5 of the machines connect to a SQL server via ODBC with no problems. The sixth PC however does not connect to the server giving the following :- Connection Failed SQL State '01000; SQL Server Error: ...more >>

Hello, What are the limitations for SQL 2005 Express. ie How many concurrent users can you have, what size database can you have etc. Where can I find this type of information? I have searched the MS site with success. Thanks in advance, Phil ...more >>

I've installed SQL server 2k5 and all services on a WIN2k3 SR2 server as a named instance (SQL2k5_01) (There is no default instance and this is a brand new server), and while I was able to establish a local connection from the management studio I needed to type in the instance name after it l...more >>

Hi, I'm trying to simulate a pure HTTP connection between two SQL servers. I have 2 machines on the same LAN both running SQL Server 2000. On both machines I have turned on the firewalls and only allowed traffic on port 80. In the Client Network utility on one machine I create an alias f...more >>

Hello World, Microsoft SQL Server Management Studio Express 9.00.2047.00 From ASP (ASP3) code, coudn't connect SQL Server 2005 Express (on the same local machine) Get error: Cannot connect to ..... Login Failed for user .... Error: 18456 Error occur, when try to connect under different...more >>

Hey everyone, We are running MSDE on a Windows 200 server and it has data in it. What I would like to know is can we also install MSSQL 2005 on that server and have assess to both databases. Is there anything we have to do to install it and make sure it doesn't overwrite or delete the MSD...more >>

I have an intranet application that comprises an ASP.Net application connecting to a SQL Server DB The application has 150 users. At the moment I am connecting using the following setup I have created a MyApp_WebUser user in SQL Server. My connection string, which is stored in my web.config...more >>

hi i make smal Application to get information from SQL Server 2000 by using VB6. now i can get Databases, Tables and Colomn, and Stored Procedures, but my problem how i can get SP Parametres? i am thinking to make small function to get Parametres From SP.Text, but i think its not good solut...more >>

Hi, I am trying to restructure the current system now. I would like to consult which programming is good for front end application to link to SQL DB? Thanks Char...more >>

Hi, I have a SQL Server 2000 running on Win2k3. I uninstalled SharePoint so I could install Reporting Services and I upgraded to MDAC 2.8. I tried connecting to SQL locally on the Enterprise Manager on the machine but I get this error: "Server does not exist or access is denied." The odd th...more >>

I have been trying to remotely connect to a test box installed with Windows 2003 Server (Web Edition) and SQLExpress but I just get the following error message: Connection failed: SQLState 'HY000' SQL Server Error: 0 [Microsoft][ODBC SQL Server Driver] Cannot generate SSPI context I think...more >>

This is a small test network while studying for my MCDBA. I have 2 MS 2003 servers, 1 XP Pro WS. SQL 2k SP4 is loaded on one server and the WS. I can open enterprise manager on the WS and connect to both SQL servers. BUT when I try to connect to the XP Pro SQL from the 2k3 server, It fails...more >>

Hi, I installes sqlserver 2005 express on windows server 2000 sp4 (name=pen1800). When running this: 'sqlcmd -S pen1800 -U administrator' in a dos window as administrator, i have first to enter the password and then i get this error: "Microsoft sql native client: login timeout expired" and...more >>

I installed SQL Server 2005 yesterday on a freshly installed Windows 2003 R2 standard server. I installed with mixed-mode authentication and was able to connect to the database. The server was then changed to a PDC with a new forest and domain. I am now unable to connect. What changes do...more >>

I'm trying to connect from a client-computer via MS SQL Server Management Studio to SQL Server 2005, Analysis Services 2005 and Integration Services 2005. The problem is, my client is in domain A, the server is a development-system in domain B, A and B are not trusted. With SQL Server I coul...more >>

Riporto la mia situazione, che ritengo possa essere una situazione "tipo" piuttosto semplice e familiare per chi opera con Sql Server, ma purtroppo sono 2 giorni e 2 notti che tento di conettermi al server SQL invano. Premetto che prima di postare questo messaggio ho letto praticamente tuti i ...more >>

I have a connection string I use in a communication program I have created and I'm curious about something. Here is the string I use: connection-string="Driver={SQL Server};Server=localhost;Database=MyDatabase;Uid=MyName;Pwd=MyPassword;trusted_connection=yes;Integrated Security=SSPI;" I...more >>

Hello all, I have just been handed what seems to be a hot potato... We have an ASP web application that is accesses a cube on an Analysis Server. The backend AS Server for this application is being migrated to some new iron. The cube has been configured / processed on the new server. AS ...more >>

Hi, I had a C# .NET application that connected to SQL Server with ADO.NET. All went well. Then, I had to change the connection to an ODBC connection (to be able to later connect to another type of db, too). When I start my app, the app connects twices through ODBC with the SQL Server - ...more >>

On a shared hosting account, I've got access to an SQL 2000 database on a remote server. Stats are data size: 12MB, Log Size: 25MB. I set it up five years ago, and, uh, forgot how I set it up... Anyway, I need to be able to view and browse the structure of my SQL 2000 database - and it would b...more >>