Hello all, There is a group GROUPA1 that contains another group GROUPB1. The GROUPA1 is a db_owner of DB1 database. UserB user belongs to GROUPB1. GROUPA1 and GROUPB1 use window authentication. Can UserB access the DB1 database? Can UseB have a db_owner? Thanks in advance, Do. --...more >>

hi there, I am installing a network managing tool in a test environment that relies on sql database. when opening the pull down list I can see all sql and msde server from my colleagues but mine. When introducing it manually with all credentials and domain info and hit "test logon", it ret...more >>

Hi I have c# application that uses SQL SERVER databases. The problem is that after I close all connections to a database in order to make actions (detach, copy or delete) on the current database I get a message saying that the database still has connections. At the Enterprise man...more >>

I have port forward 1433 on the firewall and tried to connect remotely to the server but could not get it to connect. Is there anything that I have to enable from the server? Any tool to test this? Thanks, George ...more >>

Hi Guys, I AM USING DISTRIBUTED TRANSACTION WITH 2 sql server 2000 on win2k and is working fine. but the same transaction not working in win2003. i am getting the following error. Server: Msg 7391, Level 16, State 1, Procedure P2, Line 5 The operation could not be performed because th...more >>

sometimes, if I connect DNS name for localhost running sql2000, (go to the router and back) at a simple "SELECT * FROM table" statament I get a long delay (application hangs for 10-20 second), and drops the connection. When I change the datasource to "netbios" name, the same statament works with...more >>

when i am connecting the sql server in windows 2003 using the sql analyser the following error occurs Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. the authentication mode is mixed. ICF is enabled. aliasing...more >>

the following error occurs when connected to a sql server hosted in a win 2k3 . Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. the authentication mode is mixed. ICF is enabled. i am able to connect loca...more >>

I'm writing an Access 2003 ADP project and need to connect to a remote Microsoft SQL Server 2000 database. I'm unable to connect, and I'm pretty certain the problem is in the "server name" field. I get this error: "Test connection failed because of an error in initializing provider. [DBNETLIB...more >>

Hello there, I am experiencing performance problems with an aplication running over a SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM memory. When there are just on or two users working, the aplication performance is suportable, but when more users are using the...more >>

Until recently (stopped working this week) I have been able to backup my sql database (on a windows 2000 server) to a mapped network drive(mapped to another 2000 server). I am a user on both servers (administrator). I can see the the drive in explorer. I can access the files. I cannot see t...more >>

How can I connect to database from a remote computer in the same domain? I developed many database applications using Access, but now I need a code snippet to make some of my existing application to run in a remote Sql server with the same structure (databases, views)....and I can't figure how....more >>

We have a production web site that's data intensive (save user input to DB and query for displaying) with the ASP.NET app part on one W2K server and SQL 2000 DB on another W2K server. I have set up performance logs to log # of pooled database connections on the web server every 60 seconds (.NET ...more >>

Hi everyone, Is there a possibility to block SQL user using Enterprise Manager from listing other databases on SQL server? Every user can see the list of databases but can change only his database. Is there a way to set it up just his own and nothing else. Suggestions, links, ... apprecia...more >>

Can I use a table variable to gain output using the sp_executesql procedure? Example: Normally I might have something like: DECLARE @max varchar(9),@sExec nvarchar(200) SELECT @sExec=N'SELECT @max=(SELECT MAX(ID) FROM Parts)' EXEC sp_executesql @sExec, N'@max varchar(9) OUTPUT', @max OUTPUT pr...more >>

I am having a security problem configuring a linked server to an access mdb file when the user is Windows Authenticated. I have the connection setup for all logins to use the admin account with no password. This works with no problems when logged into SQL Server with a SQL Server authenticat...more >>

Hi all - I am trying to rebuild a website abandoned by the builder and an SQLServer (I think 2k) db is used under it at the host. I can get at the db by using Access/ODBC with a URL but the migration facility seems only to let me get at the tables. There are about half a dozen SPs referred t...more >>

Hi I have a strange connection error that I believe is related to security. But I need some advice. I need to know what are exactly the permissions needed to establish a linked server connection through network using integrated security. My setup is the following for my test environment ...more >>

I am accessing a metadata table using two methods. One - grab the entire table with a procedure and use ado to filter the records in a loop when needed. Two - grab only the record needed. Recordsets use an ado client side cursor, are disconnected (static, data doesn't change except when the ...more >>

I am attempting to connect to a SQL Server across the Internet, when I attempt to register the server through the Enterprise Manager using the IP provided by the web hosting provider, I get the following error :"SQL Server does not exist or access denied" , I was told by them that I should cha...more >>

After dropping a new SQL server system with 2003 Server standerd edition into the network, the Win 98 systems cannot make an ODBC connection to the server. Is there resolution to this issue?...more >>

Greetings - I'm working with a SQL Server 2000 database via an Access front-end and I'd like to check if the user has a login (via a pass through query I imagine) on the database before attempting to pass the connection string. The user login name will be the same as their PC login name ...more >>

Greetings, In our company we have different kinds of SQL databases and SQL servers. We are trying to consolidate those servers under a couple of powerful servers. But when we began to tell this project to software houses and ask their idea; we met a big problem . Some of those companies ...more >>

I can address Linked Oracle Tables with no catalog name but I CANNOT address MySQL tables with no Schema Name MySQL_LinkName.CatalogName.SchemaName.TableName For Oracle I use with no problem: SELECT * FROM HBA..HBA.CHARGES But For MySQL I have tried it all SELECT * FROM SPMINLINES...more >>

I am in the process of trying to evaluate setting up a System Area Network and linking several SQL servers using the VIA protocol. I am having some difficulties in finding good resources on how to go about setting one up. I'm also having difficulty finding a good variety of adapters that have dr...more >>

Hi, I am asking a generic question about SQL server (or any type server communication for that matter) and how one would keep the connection open for the life time of the application, or should one close the connection for each request (or set of related requests)? Does SharePoint open / cl...more >>

Hi everybody, I have a great problem with Sql Server connections in Pocket Pc. When I try to create a connection with an Sql Server 2000 with Visual Basic.NET 2003 (I have Windows XP), I receive the error : "SQL Server does not exist or access denied". My connection string is something like: ...more >>

Hello, We have a client-server application written in VB 6.0 that connects to a SQL Server instance on the local network. We're interested to know if we are able to use our same VB 6.0 application but connect to a SQL Server that is hosted on a web domain. That is, if we have our SQL da...more >>

Have just changed over from Access to SQL server 2000. Having connection difficulty at one client only!! 2 pcs on network - both win 98. Local machine connects to server fine, but when connecting to sql server via network a dial up box appears. When I "cancel" I get the "access denied or d...more >>

The following message was posted on 17th, and I still have not received response yet. My registered alias is Wcharts@newsgroups.nospam. In Windows 2003, when I use ASP.NET page to make trust connection, I got following error messages. “Login failed for user ‘NT authority\Network Serv...more >>

Hi, I've been searching the web for some time, without any luck ... Is it possible to connect to a SQL Server using a domain account that is marked as a non-interactive user ?? Thanks, Marc ...more >>

I just installed SQL SP3 and it immediately solved the problem.... Thanks for the opportunity to post. Joe *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

I installed SQL server 2000 on three different machines. A, B, C. A is running XP Pro B is running XP Pro with SP2 C is running Windows 2000 server using the SQL Server Enterpize Manager tool i attempted to register each of the Servers from each machine. on machine A i registered local,...more >>

I have SQL server 7 running as a default instance and I'm trying to install MSDE 2000. I was able to install it as a named instance by running the following: setup.exe SAPWD="password" INSTANCENAME="named_instance" Now I can not connect to the named instance with OSQL. What do I need to do ...more >>

Hi, I'm using c# to connect to a sql database. My dev work is fine and it connects; when deployed to the live environment, it needs to have special chacters (@ and !) in it. The ! goes through fine, but @ is removed. If I hard code the @, it's fine, but my setting is held in a variable....more >>

i want to create some queerys in MS-SQL 1) this queery in ORACLE-SQL works fine , in MS-SQL? SELECT code_card, card_date + 31 FROM card i searce and find out that i must use "DATEADD ( datepart , number, date )" but how? 2) this queery in ORACLE-SQL works fine , in MS-SQL? ...more >>

Connecting with query analyzer to a local default instance. 127.0.0.1 works, localhost fails, . works, and (local) works. Why would localhost fail? TIA, Rick. ...more >>

Hi all, I've created a database with 1 table, Articles. In that table, there are 4 colmns: ArticleID(autonumber), Title, XMLFile and Date(date/time). I want to write an SQL command to get only the newest entries. How can I solve this? Thanks, Vincent ...more >>

I have some SQL server jobs that connect to a linked DB2 on an AS400 and fetches some data and inserts into SQL server. The AS400 is set up as a linked server. The jobs fail at times and work at others. The error message I get when trying to look at the tables through Enterprise manager is ...more >>

I'm having problems Registering servers in Enterrpise Manager. This problem is workstation specific. Workstation is XP Pro SP1, in an Active Directory domain. Only protocol in machine is TCP/IP. I have 4 machines with identical hardware ghosted from one source image and all have t...more >>

SQL Server 2000 on Windows 2000. Is this possible. I try to create a new backup device and the only thing I can locate is the local partitioned drives. I try to put in a UNC and it does not work. Is this not possible to put in a UNC to a shared drive on a PC. The backup is needed ...more >>

Receive this error when starting SQL: SuperSocket Info: Bind Failed on TCP port 1433 SQL Error Log: 2005-01-12 16:01:35.78 server Using 'SSNETLIB.DLL' version '8.0.766'. 2005-01-12 16:01:35.81 server SuperSocket Info: Bind failed on TCP port 1433. 2005-01-12 16:01:35.82 server ...more >>

Hi, I have a client who is conneting to my server from theirs via a linked server they've set up. They perform the following query: DECLARE @abcid int SET @abcid = 123 SELECT abc_id FROM [Server1\NamedInstance1].DB01.dbo.View01 WHERE (abc_id = @abcid) The execution plan in Qu. An...more >>

Hi All, I would like to be able to connect to a remote SQL Server and fire arbitrary queries, browse tables, and so forth. Very much like MS's "SQL Server Web Data Administrator" (link: http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylan...more >>

Can someone point me to documentation related to the number of connections a database can have before there is a degradation in the connection? I was told that if you have a database on a computer with a Windows 2000 operating system you can only have 5 connections to the database or the co...more >>

The error message that i get is: PROVIDER CANNOT BE FOUND. IT MAY NOT BE PROPERLY INSTALLED. When i run the same connection from the server to the application installed on the server it works fine. Any ideas would be helpful Thanks Tom...more >>

I have the following situation: I have a database on ServerA and a database on ServerB. My client app connects to ServerA and uses a stored procedure to retrieve a dataset from both ServerA and ServerB. While developing the app (using SQL 2K Dev on my workstation), I used a linked server a...more >>

Hi, I installed SQL Server 2000 personal edition on my Win XP sp2. In the enterprise manager, I can manage my local database, but if I try to connect via the Query analyzer, it says it cannot find the server or the access is denied. I added localhost in the Client network utilities and ...more >>

Hi, As we know,SQL server listens on port 1433 by default. Is there any dependency between client and SQL server for this port number?I mean, how will know the client that on which port the target SQL server listens? Suppose I change this port number to 1533 and restarted the SQL server.No...more >>

my SQL Server version is 2000 How to register New Sql Server with local machine? and how to connect? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>