The client wants to use TCP/IP as the network library and windows authentication instead of Mixed mode. After some time searching, I found this article... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconDatabaseSecurity.asp which states: For SQL Server 7.0, i...more >>

Hi, I have a problem when I'm running linked servers from SQL2K Develop Edition SP3a to Oracle 8i with MDAC 2.7RTM. OS: WinXP SP1 I get following error : OLE DB provider 'MSDAORA' reported an error. The provider did not give any information about the error. OLE DB error trace [OLE/D...more >>

I am attempting to import an access mdb file from a remote server. When I run the import wizard I get the follwing error: "Cannot start your application. The Workgroup information file is missing or opened exclusively by another user." I have checked to see if the lock file is there but it...more >>

Connection could not be established. The server is up and the SQL Server Service is running too. What could be possibly wrong?...more >>

Using SQL 22000. I can use the user connection counter to determine the number of user connections. How can I identify what accounts are making the SQL connections? Any suggestion would be helpful. Thank you ...more >>

Anyone ever get this error: Cannot generate SSPI context We started getting this all of a sudden on our Win2k SQL2k box when trying to connect to SQL server with Windows Authentication. Any ideas? Thanks. - Jeff...more >>

Hi all, I am very new to SQL world. I was wondering if someone could help me connect to a 2nd instance to a SQL server. I need to get a application that connects back to our main SQL server. This server has only 1 ip...but 2 instances, how can I get the app. to connect to the second i...more >>

I am having problems registering a SQL 7 database in Enterprise manager. The node that is causing problems is running W2KSP3 and SQL7SP3. Each node (bar this one) on our network (VPN) is registered with our central admin node for any maintenance we need to perform. I have tried the re...more >>

After I transformed a table from MS SQL Server 2000 to Oracle DB using DTS, I tried to query that table in the sql plus of oracle, when I do select from tab it appers but when I try to select from it or describe it, it gives me invalid identifier. What is the problem??????? SQL> select * from tab...more >>

Hi, I have a server alias called ALIASDBUK which points to a server called SERVER1. This is setup in the client network utility. In SQL Server, I have a linked server called ALIASDBUK which points to SERVER1 via the ALIASDBUK alias. In other words, the linked server has a value of ALIASDBUK...more >>

Is it possible bind the SQL service to a specific network adapter in a multihomed machine w/ diffent subnets on each adapter? If so How? Thanks, ZAN...more >>

I am having trouble connecting to an sql server over my internet connection on a LAN. I have set up DSN on the server, ( do I set a DSN server name on the client as well?). I can connect using a dial-up connection with this code but when I use my ISDN internet service, I have no luck. I a...more >>

Hello, can someone please tell me what is the max number of instances a single login can have open and running a query at the same time ? Basically i want to know if a user logs into a website and runs a query using a web login called 'weblogin' and at the same time more users try to exe...more >>

Unable to login to Local SQL Server in order to retrieve info in a DataSet. No problem when using Enterprise Manager or from within VStudio server Explorers. Also no problem with coding as able to connect to retrieve info from remote server. Therefore, feel problem lies with permissions or...more >>

Yesterday I upsized a test project I had in Microsoft Access 2000 to an ADP Project using MSDE. Everything went smoothly and i was able to connect to the data from the access table view and modify my forms and bind controls and do everything normally. This afternoon, when I open the same ADP ...more >>

Is there any way in sql server to link a table in ODBC data source(Access database on our network)? Thanks...more >>

Hi there, I'm having a small problem with my SQL Server when the Internet goes down in my network The structure we have is something like this: INTERNET ----> Linux Server --> Switch Connected to this Switch we have our PDC (Wind2k Server Small Business) with our client machines ...more >>

ok, my goal here is to import data from various ACCESS databases after washing the data in T-SQL. My first tack is connecting to the various MSAccess databases. any help would be greatly appreciated. Rob W ILX Resorts...more >>

I've created a VB6/SQL server application on a local machine and than transferred the database on a company's server which I can access from my PC without any problem. To make sure that I'm accessing the DB on the server I disconnected my local DB. Then I've created VB setup package and g...more >>

Hi! In short, my problems is that for some unknown reason my webserver cannot connect to neither remote or local SQL server database. I keep getting: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist o...more >>

Hi I have an SQL server, which (for some unknown reason) will not start as a service. Whenever it is tried to start (either using SCM, NET START, or Enterprise Manager), it reports the following error: "System error 1058 has occurred. The service cannot be started, either because it is ...more >>

Sql server running on Small Business Server using 7 XP clients will randomly drop the application connection to the database from random clients. The only way to re- connect is to Logoff and back on to the network. When this happens, the client workstation still has access to all network s...more >>

Hai, In a VB Application,I am using BeginTrans and CommitTrans methods to save data into the SQL Server 2000 Database. If the system get structed before executing commitTrans,the database become inaccessible and the other applications cannot communicate with the database showing connection Time ...more >>