Hello, I have done something VERY stupid. I was quickly creating a script to create a database. Included in my scripting options were script all database objects, and both drop and create all selected. When I ran the script, I dropped ALL logins for the server. Now, I can't get on as the ...more >>

I assume that the number of connections that SQL Server 2005 Standard can concurrently have will be limited by the operating system it is running on. If that OS is XP Pro, how many concurrent connections can SQL Server 2005 Standard have? -- Michael...more >>

Hello to all, I have a problem in connecting in a MySQL database. I can create some ODBC connection, but I can't use it to manipulate data. I like Know if Existe a MySQL Provider for SQL Server 2005 that alow me to create connections and manipulate date withe this connections. Thank you in ...more >>

I have a Linked server from Sql05 64 bit to Oracle. I am using the Oracle OleDb driver because their is no MS to Oracle Provider for 64 bit SQL databases. If I am in management studio I can query the Oracle database. However, if I am in a .net 2.0 web application the Oracle connection will ...more >>

Is there any way to: pull SQL Server 2005 database tables into a SQL Server 2000 database, without installing Management Studio on the SQL 2000 server? ...more >>

I am connecting from an Access front end to a SQL Server 2005 Express database on a remote PC. I have enabled TCP/IP on the server and turned off firewalls on both boxes. The remote PC is called EmpDB, the instance is called SQLEXPRESS the database is called EmDataSQL6 My code follows - thi...more >>

I'm having problems setting up an ODBC Connection to AS400 The server is Windows 2003 R2 64 bit with SQL 2005 SP1 Standard Edition (64bit) Using the Iseries Access ODBC drivers I've created a system DSN called MSSQL_GACUPR01 (I have both 64 and 32 bit drivers from IBM and have each) From ...more >>

I am having a problem logging in with the "SA" account on a SQL Server 2005 Express server (latest service pack). Here is the error message: "connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error:...more >>

Hi all, I am getting the error below: I would like to also mention that this error is occuring randomly. I am running a web application under SQL Server 2005 and .NET framework 2.0. Has anyone encountered this issue. Error occurred during report data retrieving and binding. The actual erro...more >>

I'm new to SQL Server 2000. I decided to purchase this server because my old company (UPS) used the server to help expedite queries and manage on-line reporting. So, now it's up to me to utilize and understand the new server. I have been using MS Access as my front- end for several ad-hoc dat...more >>

I am failing to connect to any of three SQL2000 Dev Editions from Management Studio running on Vista machine. In MS I get "under default setting SQL Server does not allow remote connections (provider: Named Pipes Provider) ...". I have also tried TCP. ...more >>

Hi, a weird thing is happening in all development PC in the company. The developers have some MSDE instances created in their machine, used for different purposes. When someone create a new instance after installing Visual Studio 2005 (some with and some without SQL Server 2005 Express Ed...more >>

Hello! I'm trying to figure out if it's possible to reach the database on my development machine from the outside (internet). To test this I'm trying to connect to the database from the development machine by using my public IP address. I also opned port 1433 in my firewall. Is there any...more >>

I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL Server 2005 Developer Edition version 9.0 on another (B). I can see the 2k server on A from Management Studio on B but I can't see the 2005 server from Enterprise Manager on A. Is this a limitation or have I just done someth...more >>

Dear all, I have setup a database under SQLexpress 2005 which is install on a Vista OS. I can manage without any problem my database from the VIsta workstation. Then on an other PC, I am trying to create a connection to that databse with ..NET 1.1, but no luck I ma using similar conencti...more >>

I am running Windoes 2003 Small Business. When trying to connect to my company website I get the following error "Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com." ...more >>

Hi All, I have Domain A with several SQL servers installed. One WinXP Pro laptop user reports that he can't connect to any SQL server instances using Windows authentication (the servers run win2k3 OS SP1 with SQL 2000 sp4 & 2005 sp1) and gets the error: Cannot generate SSPI context. (....more >>

I just installed a fresh SQL Server 2005 MSDN and tried to use the management console, but all attempts to logon fail. Message says 'failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.' How can I change these settings or otherwise g...more >>

I just installed the VStudio 2005 & SQL Std 2005 software then immediately Installed SQL2005 SP2.. Problem is that for whatever reason SSMS did not install and now when I attempt to modify the SQL2005 setup I get a versioning error and my system hangs..... How can I install SSMS at this point...more >>

I am trying enable the SQL Server Browser Service. I have enabled the TCP/IP and named pipes remote connections. When I try to launch the Surface Area Configuration for Features, I get "Falied to connect to server localhost\Microsoft##SSEE (Microsoft.SqlServer.ConnectionInfo) "An error ha...more >>

When I try to backup a SQL 2000 database I recieve the following error in the output log. Any ideas? Thank you. SQL 2000 w/ SP4 [39] Database SolRounder: Database Backup... Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK] [Microsoft SQL-DMO (ODBC SQLState: 42000)] Erro...more >>

Hello All I have a server running SQL Server 2005 Enterprise as a default instance and a named instance which is SQl 2000. The named instance is only running between 8 and 9 pm each night (Started and stopped using Windows scheduler) When I use Management Studio to browse for available SQL...more >>

Hello, I have an aspnet application which uses "dbcom.mdf" file located in App_Data of the application. I can insert, delete etc , using stored procedure etc .... Everything works properly. Now in order to centralise the database, i copied that .mdf file into c:\program files\Microsoft s...more >>

Microsoft OLE DB Provider for ODBC Drivers error '80040e21' ODBC driver does not support the requested properties. Seems like this problem started just after midnight March 11, 2006 and continues to happen every Sunday morning between 1 and 2am. My database will not allow any more ODB...more >>

Hil. I am trying to connect to Sybase to get the data in SQL Server 2005. I try to use SSIS 2005 to import the data into sql server 2005, is there away any drivers for sybase? I need immidate help. Please help me out....more >>

I use win 2000 sever as server, xp or win 98 as clients. If I set dsn each xp client, why can it not connect server (sql server)? But it can see sharing folder on server? ...more >>

I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL Express 2005 version 9.0 on another (B). I can see the 2k server on A from Management Studio Express on B but not the other way round. Is this a limitation or have I just done something wrong? Thanks in advance. Peter ...more >>

I have a customer That's running Sql Server version 8 on his main server. He also has a 2005 version on a second server on the same network. I am trying to connect to the 2005 server via the web, but can only seem to access his main server. Is there any way to specify a port or a named ins...more >>

Hi All, I'm unable to make connection to my sql2000 instance, I tried to search the knowledge base on msdn and failed with their solutions (defining alias). Can you give me some advice on this ? Cheers. Gultekin KOMANLI ...more >>

We have some legacy processes written in C with embedded SQL. They were compiled with MSSQL2000 libraries and used db-lib for database connections. After the database was upgraded to MSSQL2005, they could still make the connection. Recently we have applied MSSQL2005 service pack 2 on the test ...more >>

Hi all, I have these lines repeated many times, every 1 second, in the error log: Login failed for user 'user' Login failed for user 'sa' Login failed for user 'root' Login failed for user 'admin' Is someone trying to hack my SQL server (version is 2000)? How can I control an...more >>

Hi, I have SQL 2005 developer edition on my laptop. I am wondering if it is possible to work with databases created for sql express edition. What I mean, is that I have VS 2005, I created a Personal web site starter kit. The wizard creates database files in the app_data directory. So is it po...more >>

Hi, How do I disable in sql server ----- ansi quote identifiers in sql server. ansi nulls, padding, warnings. I set up an ODBC connection If I turn these off --- doesn't work , It works it tehy are checked. Any ideas? Thanks ...more >>

I have a VB6 application that has MSDE as its current backend. In testing moving to SLSQLExpress I've noticed, since this application is run on laptops, that if I disconnect the network cable while I'm in the VB6 app I lose "connection" to the database. If I end task on the app and restart it i...more >>

Perplexed...Why am I able to get a connection to my SQL Server from an Access 2003 database via DSN linked SQL server db table without a common protocol between the client and server? Could it be that the client does have TCP/IP or Named Pipes enabled but they are just not showing up in the cli...more >>

Hi, I have installed sql server 2005 express on a Windows xp system with windows authentification. I did this with my administrator account (dan). When i start sql server management studio, i see: user name: myserver\dan . Now i want to create a new login, so i rightclick on 'logins' in 'S...more >>