On 12/31/05, Shaun Raymond wrote: Hello All, My name is Shaun and I am using the ctp beta version of SQL Server 2005 with the following: Server Name: P3XP Authentication: Windows Authentication User name: P3XP\SRC Password: I do not need a password to login this way When I cl...more >>

I have a Windows Forms application in C# (VS.NET 2005) that accesses SQL 2005 web services using integrated authentication. In development (Windows XP Pro, SQL 2005 Dev) the SQL servers are on the same workstations as the client and connectivity works fine. In testing, the windows app is b...more >>

Hello, I am experiencing wierd problem: My SQL server is on one PC, and the (Classic) ASP web application is on another PC (let's call it AppPC). The code in ASP is trying to connect to the MSSQL server, using standard OLEDB connection string: > Provider=SQLOLEDB;Data Source=servername;...more >>

Hello all, I connect to SQL server using SQLDMO to update the database and make many Other tasks. I installed SqlServer2005 on a test server and I got an error using the connect method of SQLDMO. Is SQL Server 2005 is 100% compatible with old SQLDMO? How to make it working with the SQLDMO, re...more >>

ls, We run MSSQL 2000 on a W2K3 machine. There is an accounting software (Exact Globe) that access its data by means of SQL. For some reason I can only connect to the SQL server as ADMINISTRATOR. Though I created a group, put members into the group. I put this group in logins/security under ...more >>

Hello there I'm working with query anlyser. Is there a way with code to transfare to another server? ...more >>

Hi everybody, I developed a windows application that connects to Sql server 2000, using windows authentication and it works, able to retrive and other data process. But when I used it on Sql Server 2005 Express, it was unable to retrive data. What is wrong with it? How can I fixed this? ...more >>

Hi, Anyone can tell me on how to set up a linked server from MsSQL 2000 to Ms Access XP ? My Access MDB is a password protected database but doesn't use Workgoup Security. ...more >>

how I can connect remotely to SQLExpress?.. I have enabled TCP/IP, but it does not work. error: ..... When connecting to SQL server 2005m this failure may be caused by the fact the under the default settings SQL server does not allow remote connections (provider SQL Network Inter...more >>

Hello together, I've got the following: SQL Server 2005 Express & SQL Server 2000 The sql server 2000 has got a database with some tables, which I want to show as view (readonly) in the sql server 2005 express. Now I did the following: I added a linked server to the sql 2005 I've choosen ...more >>

I was not able to connect to local sql server 2005 express database through the ms jdbc driver, my local sql server 2005 server name is: DENLAP0059987\SQLEXPRESS, my java code is following: .... Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); DriverManager.getConnection...more >>

I am implementing my first webservices with Visual Studio 2005 with connections to SQL Server 2005. Here is the problem I am experiencing. When I try to execute code for the webservice (local or remote) I get the page returned with the primary error: System.Data.SqlClient.SqlException: Lo...more >>

Hello, I don't know why i can not connect to a remote Sql server in my Enterprise Manager, While i can do it through Query Analyzer. Thanks...more >>

2 servers SERVERA & SERVERB, are both SQL 2000 SP3a on Windows 2003 server. Named instances. Use tcp and named pipes. Everything worked fine when my desktop was Windows 2000 before. I upgraded my desktop to Windows xp sp2 last week and then i started to get the "SQL server does not exist...more >>

Hello, What is performance difference between joining tables 1. from the same database 2. from different databases located on the same instance of MS SQL Server 3. from different databases located on different instances of MS SQL Server (linked servers) when these instances are locat...more >>

Hello EveryBody, If SQL SERVER is configured as a Maximun concurrent user connections = 1 (I know 0 = unlimited) in Connection tab of server property ? Who will able to login to server ? Because i have a similar case and not able to login with any other sql server Login. Is SQL SERVER ad...more >>

I am having a problem with a query statement when I try to use sum( ) on a field in the query. For example: select somast.fsono, somast.forderdate, somast.fcompany, sorels.fduedate, sum(fnetprice) from somast inner join sorels on somast.fsono=sorels.fsono where somast.fstatus<>'CANCELLED' ...more >>

Hi, I Receive this message when I try to connect sql server 2005 express... Cannot connect to LOCAL\SQLEXPRESS. =================================== A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider,...more >>

I am trying to connect to the SQL Server Integration Services on my back end 2005 database server through SQL Management Studio. When I try to connect I am receiving the following errors: TITLE: Connect to Server ------------------------------ Cannot connect to server. ------------------...more >>

How to install Sql server 2000 by use sql authentication? In stand-alone computer. Please show step install program. Thank you....more >>

I have enabled remote TCP connections on my server *AND* i am able to connect remotely through the management studio on my laptop. however, when i try to connect programmatically, i get an "invalid connection" error. Connection String: "data source=xxx.xxx.xxx.xxx;initial catalog=mycatalog;U...more >>

Hi, I would like to know how MSSQL 2005 calculate they CAL? If I implement my database to a webservices ( HTTP EndPoint ). How many CAL do I need? Since all my client application will connected throw the web services. Do this type of implementation incurred any limitation? Thanks ...more >>

I am interested in having two databases that are on the same server connected together. I have the individual databases but I also want to have a common database that keeps stored procedures to do things such as changing password. I don't want to cut and paste them into each database each ...more >>

Can you create linked SQL servers across domains ? If so do you need to do something different from a normal linked server ? Thanks Si...more >>

How to set user and password connect to Database server from other program when Sql server 2000 authentication by Windows ? And How Change Windows authentication to Sql server authentication....more >>

Hi All: I really Shocked,These days I just really shocked what`s going happen behind the WindowsSP2 and Windows Server 2003 (SP1)?? when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1) But I can`t connect through those. We have a Software that install MSDE DB instance on th...more >>

Sql 2k enterprise on Win2k3 Advanced (both at SP4). Large network, 1 Parent Domain, 20+ child domains. (2000 Native). Having intermittent trusted security issues with a couple of the child domains.. When users try to connect to SQL server they get error: Unable to conecto to server [serv...more >>

time stamp magicaly updated when ever update event occures on a row in sql server 2000 i have a table. when i do any update on the table, a field of the effected rows gets a new time stamp, there are no triggers on the table, nothing special in the DDL of the table, is there any other way bes...more >>

Have Visual Web Developer ; came with 2005 SS Express - problem is there is no way to create a database, much less stock it with test data; nothing like a Server Enterprise Manager seems to have installed, and MS Access projects wizards don't connect to it either - (BTW: VWD seems very well d...more >>

Dear all, Do you people know how to connect MSSQL 2005 express edition with Vb6 ADODB? As I know MSSQL 2005 express connection string is specific the database path. How do I write the connection string for ADODB? Thanks in advance, Goh ...more >>

During the installation process of SQL Server 2005, Setup complains it cannot connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe. I have checked that the pipe exists (\\.\pip...more >>

I installed SQL 2000 server on my PC (OS: XP Professional). I wrote a Visual Basic application that retrieves data from the SQL server that is installed on my PC. When I start this application at my computer, it works. When I start this application at another computer in the same network, it f...more >>

On my machine I have installed : Visual studio 2003 - .NET 1.1 Visual studio 2005 - .NET 2.0 All the application made by VS2003 don't work if I try use SQL 2005 (all work fine using SQL 2000) If I try make a connection from VS2003 to the SQL2005 server (using VisualStudio Server Explorer...more >>

I have a problem. We have a SQL Database that connects to 2 clustered servers. The 2 servers are turning off alternatively almost like the plug is being pulled. There does not seem to be anything wrong with the servers themselves. Can SQL send anything that would turn a server off ? Don`t t...more >>

Trying to extract data from two databases on different servers... I know how to write Select statements to get data from them seperately but have not managed to join the two together. Can anyone help with this issue? Thank you ck...more >>

This is to do with SQL Server 2005, but I think it is a more general issue. We have two SQL Servers, but starting with bog-standard Domain accounts and both running in Windows Authentication mode. Either account it trust for delegation, nor are the machines, as we do not need delegation and d...more >>

Apparently SQL Express 2005 doesn't support multiple users/connections ... only one user connection can be established at a time. Does any know if this will this change in future versions/updates? ...more >>

I've installed sql2005 on win2k3, running on virtual pc... I can connect to the sql server using sql server management studio... Because I'm building base environment for testing, I seal the machine using sysprep. When I start a new machine, I get this error... "A connection was successfully ...more >>

I am getting the following error ... Connection failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myUserName'. Reason: Not associated with a trusted SQL Server connection. Upon examination of the SQL Server Log, I see t...more >>

Hello there I have two computers who connected on the same workgroup. on each one of them sql server database is installed I would like to connect them together so i can transfare data between them. What i need to do so they will recognize each other? ...more >>

If I understand correctly, SQL Native Client must be used to access the new features in SQL Server 2005. What if I just want to access SQL Server 2005 but don't use any new feature, can I not install it onto client machine and just use SQL Server driver comes with ODBC? ...more >>

Is there a way to access 2 databases simultaneously using a single connection string? server: SQLSERVER databases: gasstations customers I'm working on a VB.NET application. Thanks Bill ...more >>

Hi, This only happens on a particular user's machine so far. the user is using ms access, using odbc link to connect to SQL Server 2000 SP3a on W2k server. With the MS Access running , suddenly the error happend when i ping the sql server i can get its ip addr i have checked the ms ar...more >>

I have installed a SQL Server 2005 named instance with mixed authentication on a Windows 2003 Standard Server. SQL Server Service is running under local system account. I have not changed any default setting. I want to set up a System DSN in ODBC Data Source Administrator on a Windows XP ...more >>

I'm sure I'm doing something pathetically stupid. BUt I'd like to know what! I have a remote hosted machine which has been running MSDE for quite a while. I'm using a non standard port for connection (e.g. not 1433) and I can get to it from my development machines which have an alias to t...more >>

I was using sqlserver for asp .net applications and since yesterday I am not able to start my sqlserver. The ERRORLOG under C:\Program Files\Microsoft SQL Server\MSSQL\LOG is as below: 2005-11-30 16:37:28.89 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ...more >>