Hi I have a windows 2003 std ed server, with SQL Server 2000 SP4 on it, and a netstat -an shows port 1433 as listening, but it doesn't reply when I telnet to it! I'm very new to SQL Server, so please excuse me if I'm being an idiot! Anyone know what might be wrong? I know there is no firewall...more >>

Hi There, I'm using windows xp and sql server 2000. I installed sql server to my pc and it's workin so fine. When I log in to my windows with a domain server my sql server connection fails. What must I do to fix this problem. Is it related with sql server-properties-security. Thakns for...more >>

I'm using MSDE 2000 as database server and after I have restarted server where MSDE 2000 resides, I cannot login to database at all. I have password for user SA but when I try to login I get the message "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." Pl...more >>

I am trying to package SQL Server Express 2005 with my application. I got it to self install just fine and I am passing the DISABLENETWORKPROTOCOLS=0 to the setup file to enable remote connections, BUT still, after it's all installed I still am having a problem with the TCP connection for each I...more >>

I have Personal Edition in my desktop for development and it's quite slow to connect. For e.g. When I'm in QA and press Ctrl-U to list the databases, it takes about 5-10 seconds to show up. For a local connection this is very slow. Also, when connecting in Ent Manager, it takes about 10 seco...more >>

I am using sqlExpress as backend for iis and had to make an ip change. Suddenly I cannot remotely connect to SQL using the CTP. I chaged the ip address back to the original and still cannot connect. The box is wide open, no firewall and all surface connections are active. Still cannot connect ...more >>

After a new installation of MS Enterprise SQL Server, i am unable to connect to the database from a website, and i dont know if MS SQL is working at all. All the startup services and SQL services are started.Here is the website that im trying to access my SQL server: http://www.techparts.o...more >>

Hi All, I have an application developed in ASP.net and I'm using SQL server 2000. The application is working fine for quite long time. In the recent past it threw "Timeout expired error" while posting data into the database. The size of the database is now huge. When the server is restarted, t...more >>

I am trying to use a Cisco VPN connection to SQL Server. Zone Alarm is blocking the ports, does anyone know which ports in zone alarm that I need to unblock? ...more >>

I can connect easily using C# & ADO.NET on standalone programs. I am trying to connect from a web site program under .NET 1.1 VS 7 and always get Login failed for user 'LANDON\ASPNET'. Description: An unhandled exception occurred during the execution of the current web request. Please ...more >>

Hi Is it possible to do this using ADONET2 and how would you achieve it? My data layer uses adapters exclusively, which works well, but now I need to connect asynchronous to speed up my UI. Thanks...more >>

I have a problem connecting to SQL Server 2005. After I set "user connections" to 1 and restarted sql service, I cannot connect to server anymore. Do you have maybe any suggestion how to set "user connection" back to 0? It's a SQL Server 2005 Standard with SP1 in two node cluster. Thanks! ...more >>

hi i working on VB6 + SQL2000 i have table called (tblBuffer) and want do something in my application everytime table added new record (its like trigger in SQL) thats mean if someone add new record to this table, this table call my application to do some event. now i made small monitor (w...more >>

We have a test SQL 2005 (Developer Edition) machine on Windows2003 SP1 Standard Edition. After the reboot to install MS patches Tuesday AM, it quit accepting any SQL Connections. Prior to the reboot it was accepting connections and working as we expected it to. I've worked with the Surface ...more >>

Environment: OS of sql server 2000 server: windows 2003 standard server , .NEt framework 1.1 , sql server does not have any service pack, machine has the latest Windows service pack. Personal firewall is not enabled on this machine. All machine are within the same network. All i am dong i...more >>

I have a serval .asp page with get som data from a SQL database. Sometimes (not every time) i call one of the pages it gives me this error Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I dont kno...more >>

Hi I am possible to connect via the SQL Server Management Studio to the database in the network. I have difficulties to connect via the Visual Studio C# Express to the database. What can I do? What could be the failure? Everything works fine with the SQL Server Management Studio Express. I can...more >>

When I try to install SQL Server 2000 Desktop Engine, I get the BPsetup error that says "Unable to Create a login instance." Then when I click ok it says "Unable to Add system server role." Then when I click ok it says "Unable to add login and grant access to database." Then it aborts setup. ...more >>

I am constantly getting connection timeout error when I tried to open SQL 2005 management studio activity monitor. In connection property window, I found the connection timeout is set for 15 seconds. However I could not find place to change the connection timeout. Management studio\tools\opti...more >>

Hi all, I initially set up my server database with window connection. after two months and my window password is expired and I just noticed that the server is not started any more since the original password is not working any more. I tried to register the server with my sql user ID and pa...more >>

Hello I have a problem to connect to the SQL Server 2005 Express Edition. I have the Visual Studio .Net 2005 and the SQL Server Management Studio Express CTP but I cannot connect to the Database from the client to the database instance through the network. Could be a Domain problem, i found ou...more >>

hi i working on SQL2000, and want to make "Stored Procedure" that's working every 5 mibute, without making any calling. how i can make that ? -- Best Regards Tark M. Siala Development Manager INTERNATIONAL COMPUTER CENTER (ICC.Networking) Mobile: +218-91-3125900 E-Mail: ...more >>

Suddenly my trusted connection no longer works in VS. I try to create a new one and recieve this: "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and the database is online Login failed for user ''. The user is not associated ...more >>

Good morning we are having a wierd issue with our Windows 2003 server and SQL 2000 sp4 server. From the client side we use isql queries. When we reboot the server the isql queries that are larger then 512 bytes will fail from both the client or from the sql server itself smaller ones will wo...more >>

DearAll group menbers, I am using SQL Server 2005 and 2000. I want to link SQL Serve 2005 with 2000. When i use linked server configuration i get this message. OLE DB provider "SQLNCLI" for linked server "linked_server_name" returned message "Login timeout expired". OLE DB provider "SQ...more >>

I have SQL Server Express up and running on a PC, accessed via an ADP I would like another PC on the LAN to do the same. On the local machine everything works well, however the other machine cannot connect. I am using a trusted connection and the remote machine appears to be trying to c...more >>

Subj: ::FN_DBLOG() - Problem in retreiving [row data] Hello While attempting to retrieve [row data] column using ::FN_DBLOG an empty '0x' value is passed back: select [Current Lsn], [row data] from ::fn_dblog(null,null) The retrived record does contain row data. It can be seen when usin...more >>

Does CurrentProject.IsConnected tell me that the ADP is connected to the SQL database, or that it sees the network? I have an ACCESS ADP connecting to a SQL db via a wireless network. I thought I would check CurrentProject.IsConnected to see if I had lost connection due to out of wireless ...more >>

I have a database on a SQL2000 server that I am trying to connect for viewing in Access 2003 with the client running Windows 2000. I have created the connection, but when I try to view the tables, I get "#Deleted" in all the rows, for both tables. I installed the latest MS Jet Driver to no a...more >>

Hi, I am developing an ACCESS ADP that links to MS SQL, the SQL is on a server, the ACCESS links to it via a wireless network. When it goes out of wireless range, I will lose the link to the database. Is there a standard way to have it re-link effortlessly (quickly) when it comes back into ...more >>

Hi Everyone, I was doing some testing with client configuration and I'm seeing something I don't understand. Let me explain the setup. My setup involves a single machine running "SQL Server Express 2005". As you probably know, SSE includes the "SQL Server Native Client". I run the "SQL Serv...more >>

Hi there, this is probably a common question, how can i include the "enabled Quoted Identifiers" settings in the connection string of the sqlconnection. on trawling through web pages i have identified 1 .that by default the quoted identifiers in SQL Server 2000 is by default set to ...more >>

Please let me know whether Microsoft Access(2000), running on our office computers, will be able to link (over the Internet) to the tables in our SQL Server (2000) database on your server....more >>

I have a sql server in the local network.I am able to connect to this server through my .net windows application using both dsnless and dsn connection.But using the same code in my web application it is not connecting to this server.In this case while using dsn-less connection, error message is ...more >>

Hi New to ASP2.0 programming, I need some help on the Connection String that I want to place in the web.config file. I am running Visual Studio 2005 Web Developer and the web hosting company has is using SQL Server 2000. I need to build a connection string... <connectionStrings> ...more >>

Hi all, I got the question, how can i connection MS Access Project to a SQL Server in vba in runtime. The situation is i create a new MS Access Project, it's didn't have any connection with any SQL-server. It's just consist a couple of form. What i want is that user can via an inlog form...more >>

Good Afternoon, Really I have two problems, and Only i need one of them. Both is because I try to read the Log. The first Question is about the function fn_dbLog, how can I do to see the information of register inserted or updated or deleted. The second question is that with the DBCC Log...more >>

I have multiple ODBC connections configured and they parse the tables correctly however inside any SQL 2005 application the tables are not listed. I can run queries against any table in ProvideX however. The tables are listed in SQL 7.0 and 2000. ...more >>

I am connecting to a SQL Express database from Excel 2K. I have three connection strings examples. The first two work however the third was the one I wanted to use as I do not want to specify a local db. These two work fine: strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=...more >>

I have a SQL database and I need to link to a VFP table. I have been told that a view is what I am needing. Can someone lead me in the right direction of creating and using a view to a VFP table? ...more >>

Hi Guys, I tried to install client tools of Sql Server 2005 DevEd. Wow! Big product... but my boss imposed me to deinstall this tools. Now when I launch Enterprise Manager I get this message: Snap-in failed to initialize. Name:<unknown> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F} I alr...more >>

Our SQL Server has a linked server that we are trying to query. Our SQL-Server is on a DMZ-net, behind an ISA-Server, the linked server is not behind any firewall. I have no problem to make a connection as a linked server from my local workstation (not on the DMZ-net). Does anybody know w...more >>

Hi, I am having ongoing problems connecting to the server. I thought I had it solved thanks to help from a prev post: C:\>sqlcmd -S dimension9150\SQLExpress HResult 0xFFFFFFFF, Level 16, State 1 SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Sqlcmd: Error:...more >>