Hi all, I'm new to SQL so here goes, we got a dbase we're putting up for the web, and basically we're testing it out for connectivity, I set the system dsn with the account that's in SQL server (got the server in mixed mode auth), when I try to login to a page we put together I get this error ...more >>

Howdy, We are currently building a application on the .NET framework and using DotNetNuke (DNN) as the backend. One thing we have noticed is that DNN uses the same connection string for multiple users. I was wondering what is shared on a per connection basis? For instance, is it possible...more >>

Hi, All, I got a problem with linked server, I cannot fix it, if anyone can help will be appreciated. The problem is two instance of sql server in one machine, A and B, in A made a linked server to B. and a view in A. actually I can view the data from view, but I can not update from view...more >>

Does SQL Server 2000 Personal Edition or SQL Server 2000 Developer Edition have connection limitations compared to SQL Server 2000 Enterprise Edition? Specifically, should a database running SQL Server 2000 Developer's Edition (or Personal Edition) on a Windows XP Professional SP2 computer be ...more >>

When trying to log into a ODBC connection as a power user on a network we receive the following error: Connection failed: SQLState:'01000' SQL Server Error: 53 [Microsoft][ODBC SQL Server Driver][DBNET]ConnectionOpen (/cibbect ()), Connection failed: SQLState:'08001' SQL server Error:178 ...more >>

Hello, We have been running a web application in Windows Server 2003 and SQL Server 2000 both located on different machines. It was working fine until a week ago. There were some security patches that were installed from Microsoft site. After that we get SQL Server does not exist/Access denied ...more >>

Anybody know why I'm having problems connecting with SQL Server Management Studio to SQL Server 2005 Developer (September CTP) running on WindowsXP Professional. I'm able to connect to the instance just fine when logged into the machine but not able to connect from other machiens. I've enabl...more >>

hi... If any MS DTC sample application is available. Want to know how different modules (MS DTC, Transaction Mgr & Resource Mgr etc) work together and what protocols are being used. Really appreciate if someone help me to get an application like client/server. Thanks in advance Regards U...more >>

Hello, My project currently is this: Migrating access reports to sharepoint and sqlserver. I didn't not pick the enviornment, I'm merely attempting it. Is there any information about connecting these two? Is there anyway to retrieve information from sql server? I can write in c# but everytime...more >>

SQL Server Personal edition Enterprise Manager on Win 2000 I have the above installed on my own computer I have connected to a remote database using it's IP adress I can see all the tables - eg NorthWind With the appropriate login (Server Authentification) should I be able to create a...more >>

Using a SQL2000 server on Windows 2003 linked to a SQL2000 server on NT4 we keep getting a sp_reset_connection on the NT4 box. I'm running a job which pulls data from the NT4 to the 2003 machine wrapped in a transaction. It seems to be closing the connection between transactions. It is now ta...more >>

When i connect to the sql server 2000 and find the host_id() function it gives the result * which is terrifice. I never seen this type of host_id() is '*'. Any body knows why it gives the * result . Please Help for solution. why the host id is '*' ...more >>

Hello I am running SQL Server 2000 with SP 4 on Windows Server 2003. Every hour I receive several notifications with the following: Reply: Message not found. Insertion strings:Error: 17805, Severity: 20, State: 3 Invalid buffer received from client. I want to create a SQL Profiler ...more >>

Hello, we have an Oracle Linked Server (8i) running linked from SQL Server 2000 SP4. The performance is ok when selecting data from the sql server, but poor when trying to insert data into the oracle database via linked server. Even simple inserts ( insert into lserver..xxx.tablename ...more >>

3 workstations previously installed and able to access server. 4th workstation am able to map to server access files but when attempting to log in receive the following error. EXTERNAL DATABASE OPEN FAILURE Error: -2147467259[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server doe...more >>

Dear all, I am writing ASP to connect to SQL server. In the connection string,when I write the database server as "(Local)" or ".", it will connected sucessfully. But When I used "127.0.0.1" or "localhost", it complains with the message "SQL server does not exist or access denied", or someti...more >>

Hi , any one can suggest me wich is the best provider connection I can use for my program to connect to an MSSQL 2000, currently I use the "Microsoft ADO OLEDB for SQL" . Thanks, Paolol...more >>

Hello, We have two applications that connect to three SQL databases on another machine. Both applications access and update the databases. One application is a web application (ASP.NET) the other one is a Windows service. The web application runs fine. It accesses and updates all three databa...more >>

Hi If we use connection pooling, then a sp 'sp_reset_connection' will be executed to clean the connection. Does this sp clears the context_info for the connection or not? Our initial tests shows that it is not clearing the context_info. How to clear context_info in connection pooling envir...more >>

I can connect to the SQL Server database through Enterprise Manager and the SQL Server Service Manager is showing the database running but I cannot connect to the database through Query Analyzer. Any suggestions? ...more >>

running this now, but need the names, & not emp ID's. select ticketid, acct, date, createuser from ticket where createuser in ('k1001', 'k1002', 'k1003', 'k1004') group by createuser will the 'as' work in the IN operator? where createuser in ('k1001' as Dave, 'k1002' as Sue, 'k1003' as S...more >>

I run Visual Interdev 6... I have 2 web servers and 2 database servers... (1 of each located in my home - A; and 1 of each co-located at an ISP - B with our own firewall at each location). Location A: Firewall, port 1433 opened (for specific IP#'s) Web Server: IIS5 SQL Server: 7 Location ...more >>

hi i have sqlserver that running on windows 2003 i have connecton to this server from an other computer and i need tcp/ip connection to this sql server but i cant connect to this sql with this port when i use netstat -an i dont see this port(1433) on pro...more >>

How can I make it so that our intranet clients can connect to the SQLServer via our FQDN? Our extranet clients work fine via that way, but once they go behind the VPN, the FQDN doesn't work. Also for onsite intranet clients we can connect fine via server name, but not via IP address or FQDN....more >>

Hello newsgroup, after searching around the web, some reading and testing I'm still having problems using MARS via ODBC with the SQLServer2005 June CTP. I'm trying to enable MARS by connection string, after some looking about "MARS_Connection=yes" should be the setting. That right? I fou...more >>

SQL SERVER 2000 Personal Edition Win 2000 Connect using SqlServer Authentification Jim **pw** Run the following to create a new table:- -------------------------- USE SolutionsNet GO CREATE TABLE Companies (CompanyId INT PRIMARY KEY IDENTITY(1,1), Companyname VarChar(50) NOT NU...more >>

Hi, I am new to Networking and we have just put in a CISCO firewall so we can have VPN access to the SQL 2000 server (server 2000) but after getting the VPN in place we found that we do not have VPN access to the database. CISCO informed me that we need to set up the SQL server to have UNICAST t...more >>

I have a frustrating issue that hopefully someone can help with. I have a few remote users that connect to the sql server through 1433 and sql authentication (the ISA firewall only allows their IP addresses to connect). They connect through an ODBC connection with no Idle timeout. These us...more >>

Hi, I am trying to add a Data view to a sharepoint site. When I try to create a connection to the SQL database I get an Authentication error. I have tried both the Windows Authentication and a Username. I am a DB administrator and have full access to the database and its server. Thanks!...more >>

I am trying to link to an AS400 server. When I set up the link I am getting Error 7303 Could not initialize data source object of OLE DB provider. I know that there are problably parameters that I need to add to the connection but am not sure where to start. Can someone help me troubleshoot ...more >>

I have an application developed by ASP. I use OLE DB to connect Product Server. I can connect product server with IP address, but failed with hostname. Win2k3 sp1 and sql server 2ksp3: error: Attempting Connection with Connection String: Provider=SQLOLEDB;Data Source=Hostname;Initial Catal...more >>

Hello, Can someone explain me if it is possible to do a windows authentification on a SQL Server without using named pipe, and just using a TCP/IP (port 1433) network access. Thanks, Geof ...more >>

I'm sure this is a simple thing that I'm missing, like a setting in the Surface Area Configuration wizard or some such. Please read on... I have an x64 server (Windows 2003 Server) with a clean, named instance (there is no "default instance) install of the Sept. MSSQL 2005 CTP (9.0.1314) - ...more >>

Hi, do you know how to deploy a database (along with all the tables and data in them etc.) from a development machine to the target machine? Can I just copy the dabase file??? (Assume the SQLServer application is already installed on the target machine) Thanks!...more >>

Hello, I have a brand new install (with latest MDAC and SP) installed. In the SQL Server Network Utility both Names Pipes and TCP/IP are "enabled" I chose 1433 as the port for the TCP connection. However the SQL Server Log only shows Named Pipe: SQL Server is ready for client conne...more >>

Hi, I currently have a development SQL server running locally on my laptop. After my laptop comes out of hibernation, existing connections to the server, such as from Query Analyzer, work fine, but I can not make new connections to the server. I've tried restarting the server through the ...more >>

All of a sudden one of our network workstations received the following message when trying to access a program Microsoft SQL Service Login -Connection Failed -SQL State: 'S1000" -SQL Server Error: 126 -[Microsoft] [ODBC SQL Server Driver] Unable to load communication module. Driver has n...more >>

I have SQL Server 2000 running on a laptop on my small wireless network. It runs fine when I connect by using the servername while in SQL Query Analyzer. But if I use the IP address of the server machine, the connection speed goes from fractions of a second to many minutes. I need to use ...more >>

Hi all, i have the same problem with connecting to the sql server 2005 version 9.00.1314 .....i m trying from past two days now....i have installed sql management studio...but everytime i try to connect with it...using the server name as SHUCHI...it gives me error as: cannot connect to SHUCHI ...more >>

I have machine A hosting SQL Server ASS, and B tries to access ASS. ASS use mixed authentication mode. A and B are in the same LAN and workgroup. B use Sql Server username and passoword to access the ASS sql server. In ADO.Net and Visual Studio .Net, if I first register the Server A on Visu...more >>

Sql Server 2000, Win 2000 Problem accessing tables in SQL Query Analyser:- ?? why can't I access the database connected as Jim ?? Created Database [SolutionsNet] - Owner Jim Created Table [Jim.Customers] Owner Jim Data base access Jim 'permit' Table - Companies - permissions Jim ...more >>

We have two domains, the production domain (where SQL Server is) and the user domain (where users log in). There is no trust between the two domains. Without using SQL Authentication Method is there a way to connect to the SQL Server using Enterprise Manager from the user domain. Thanks ...more >>

We have a SQL 2000 database sitting behind a CheckPoint firewall. The server host our HelpSTAR helpdesk database. Clients connect to the database from their workstation with the HelpSTAR client. All the proper ports are open to allow communication through the firewall between client and ...more >>

For some strange reason, I can't seem to connect to SQL Server 2000 remotely from VS.NET 2003. I've tried using the wizard and doing it manually but no dice. Tried storing my connection string in my web.config file, but still no connection. <appSettings> <add key="conn" value="server=Rem...more >>

I have a computer A in Domain AA, and have SQL Server installed on computer B in Domain BB. When I connect from computer A to SQL intance in B using script or C# program, SELECT statements work fine, but when I try INSERT I get "Timeout expired." Does anyone know what I can try to remedy th...more >>

IN our network with Windows 2000 server and Windows XP clients the following problem occurs. On our accountingfirm book-keeping is done with a prograam that runs on sql-server. The following happens: After some time (approx. half an hour) SQL-server reports the following error: "Cannot c...more >>

I can connect to a sqlexpress database using aspx (asp.net 2.0) pages but not via classic asp pages. Both the asp and aspx pages are within the same website. The sqlexpress database is also on the same server. I have tried using a variety of connection strings within my asp pages, including ds...more >>

This error is being generated from a SQLServer2000 database being accessed via ASP over the web, any suggestions for fixing it? THANKS -- John...more >>

Using Visual Basic can you assign a resultant recordset to an array without looping through the number or returned records and fields. Dim strArray() as String Dim rs As ADODB.Recordset rs.Open SQLStatement, Connection strArray = rs Many thanks for any assistance....more >>

Hi I have two SQl Servers SQL Server A is on Windows XP SQL Server B is on Windows 2003 Server Using Enterprise manager i try to register Server B on Server A and am successful But when trying to register Server B on Server A I get the error : SQL Server does not exist or access ...more >>