Problem With SQL 7 And Windows 2000 - Connecting
Jun 1, 2001
I'm having problem with SQL Server 7 and
Windows 2000. We are deploying an application
made with VB6. This application is multi-users.
Our client has a network of 3 computers. One of
these computers is the server. The application is
deployed on all 3 machines. On the server,
everything goes well. It is possible to connect,
to insert new data, etc. On the 2 other computers,
with the account that installated SQL7 and created
the DB, USER1, there`s no problem at all. With ANY
other account, it is possible to access most of the
application, but some forms would just not access
the DB. We tried to give all rights to all users
on the SQL Server. Nothing. The security used is
Windows NT (2000). There is no rights on tables.
We tried to make a duplicate of the original USER1
account, with all the same rights. It doesn't work
any better.
So all our security is down, and we're still not
accessing with other accounts. We're connecting
SQL Server via the ODBC. I don`t have a clue what
to do next. Please let me know if you have any hints.
View 1 Replies
ADVERTISEMENT
Feb 5, 2008
Hi,
I have a database of Sql server 2000 in one of my windows XP machine. when iam trying to connect that database from other machine i am getting sql server does n't exist message. I can able to connect the sqlserver through the Enterprise manager but i can not connect the sqlserver through code.
I already used the same code to connect the sql server in windows 2000 machine and i connected to the database without any problem. but iam facing the problem with windows XP machine.
can any body help me to solve this problem.
thanks in advance.Mahesh
View 4 Replies
View Related
Jul 20, 2005
Hi all,I have a Windows 2003 server, which is also a terminal server forapplication, with sql 2000 installed. My company has developed anapplication that uses SQL 2000 as its database. The application is aclient/server one. In each client computer there's a link to theapplication on the server. There is no problem with Windows 98,Windows 2000 pro, Windows xp pro clients, but the windows 95 onescannot log in to the database. The log of the application shows thefollowing error:connection error -2147467259. Cannot open database requested in login'database name'. Login fails.Till a week ago the application was running on a Windows 2000 serverwith SQL 2000 install and the W95 clients had no problem connecting tothe database, so my guess is the error has something to do withWindows 2003 server, but what'causing the error?I tried to install a newer version of MDAC (MDAC 2.5, the last versionof MDAC you can install on W95)but with no success. By the way W95clients have no problem accessing shared folder on the Windows 2003server.Any idea?ThanksMarino
View 1 Replies
View Related
Apr 17, 2008
Does any one come across any difficulty in the following migration?
OS: Wondows Server 2K
DB: SQL Server 2K Standard Edition
Migrating to
OS: Wondows Server 2K3
DB: SQL Server 2K Standard Edition
Thank you,
Gish
View 4 Replies
View Related
Jul 20, 2005
Hi,I'm planning to develop a small intranet to provide our organizationwith documents online. I've decided to do this using jsp/servletsusing a tomcat server. For an operating system, I have chosen red hatlinux. However, I'd like to keep a small database on a sql server asa datasource. However, this sql server is already part of ourorganization's windows domain. I suspect I'll need to configure sambaso that other terminals on the windows domain will be able to reachthe intranet. What's the best manner in which to connect my linuxservlets to this sql server database? I suspect this may bedifficult, considering the sql server exists within a windows domain,but as a beginner, what do I know. Perhaps someone could point me inthe right direction.
View 4 Replies
View Related
Jan 30, 2006
Can't get winmobile 5 to connect to my sql server 2005 (using vs2005). Here's the connect string:
"Data Source=tcp:XXXXXXdefault,1433;Database=YYYYYY;" _
& "Integrated Security=SSPI;"
This very same string, and variations of it, work in a vs2005 winforms app, but not a windows mobile 5. I'm (obviously) using system.data.sqlclient. MS documentation says it's supported on both platforms with no syntax changes. Any suggestions?
View 11 Replies
View Related
Jan 23, 2007
I am trying to pull data from an Oracle 9i database to my SQL Server 2005 sp1 database on Windows 2003 64bit Itanium server. Each time I try to use the import wizard, select the Microsoft OLE DB driver for Oracle, I get an error message telling me that the Oracle client tools are not installed. This happened after I had already installed the 9i tools, tested the connection using TNSPING and confirmed the tnsnames file was correct. So, I uninstalled the 9i tools and then installed the 10g client tools. Tested everything after the install and then tried the import again selecting the MS OLE DB driver for Oracle. I again got the error message that the Oracle tools were not installed.
has anyone ran into this problem and if so, were you able to fix it?
View 2 Replies
View Related
Feb 17, 2007
Hello!I'm migrating an IIS/SQL-Server application from Windows NT4.0 and SQL-Server 2000 to Windows 2003 Server and SQL-Server 2005.My problem is that it is not possible to connect local (IIS and SQL-Server 2005 are runnng on the same node) using ODBC. Running theapplikation on a remote IIS (XPPro) all works fine. I can't see anydifferences in the ODBC-configuration.Any idea?Thanks
View 5 Replies
View Related
Oct 20, 2006
Hi
I have installed SQL Server 2005 onto a server and then on my client machine I have installed SQL Server 2005 and the Server Management Studio.
When installing it on the server I chose all the defaults so have not setup an sql username or password to connect as I thought I could use Windows.
I go to the Server Management and registered servers, create a new one and enter the ip address of the server and choose Windows Authentication. The following error keeps appearing though and I am not sure what settings/where to check:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)
I have checked and think port 1443 is open on the server, tcpip is enabled but when I choose Windows authentication I cannot enter a username or password as it is greyed out. It has completed the username but no password and these are not the correct ones to connect to the server - I wish to wish the same one I use for RDC.
Or should I try SQL Authentication and if so how would I set this up? Cannot see on the server in SQL Configuration where I could set this?
Hope someone who knows a lot more than me on this can help!
Thanks for your time - this has been driving me mad for days now and everything I print off the internet is not help so any feed back or more useful links to loo up would be great.
View 4 Replies
View Related
Jun 28, 2007
Is there a way to connect to database using Windows authentication as a different user than what you've logged in with to your desktop?
For example:
I log on to my desktop as mydomainme. I'm developing queries using Management Studio against a database (on another server) where mydomainme doesn't have access, but the admins have granted access to mydomainJobs1. I have the password for mydomainJobs1, and I'm hoping I can connect to the database using that account without having to log-off my local desktop as mydomainme and then re-login using mydomainJobs1.
The analogy in the file/share-permissions world would be using "net use" from a command prompt:
net use \SomeServer /User:mydomainJobs1 jobs1password
Anything similar for SSMS?
View 1 Replies
View Related
Feb 12, 2008
In a previous thread, I got some help from you all in figuring out how to deploy a per-machine desktop application and database so that it would be available to all Windows accounts on the machine. Basically the advice was to create an SQL user for the database with the BUILTINUsers login which had the necessary privileges for connection.I have tried this approach, but I am still having problems with connections for unpriveleged users. I have given the database user the role of db_Owner as well as other roles, but it seems to make little difference. I have been trying the deployment on several machines running XP, and I get several different responses. But primarily I get the "CREATE DATABASE permission denied in database 'master'" error. All of these computers seem to have the same database user level permissions, but obviously there must be differences somewhere. That worries me from a deployment standpoint.
I don't want to make any changes at the server level login properties for Builtinusers, but I have experimented with changing these, and I've found that giving sysadmin privileges to BuiltinUsers works great. But I doubt that anybody would be very happy with that solution.
I'm confused about the "Create Database" message, because I'm not explicitly creating any database at application startup time. It also seems like this might be an attachment problem, but I'm not sure about anything. Is there really an attachment and detachment of the Express database every time the application is run?
So my bottom line questions are:
Which database level privileges do I need to give to my SQL user with BuiltinUsers login so that any Windows account can connect and write to the database?
Can I accomplish this goal without changing any server level privileges for the BuiltinUsers login.
Thank you.
View 7 Replies
View Related
Sep 28, 2015
I have a scenario where I want to make a linked server query and report using windows service account credential. I can able to do link query if I RDP into the Server where linked server established using the service account and run query successfully but local client SSMS with my credential fails connecting linked server or querying. Looks to be a sql double hoping problem if so configuration each client domain account to enable delegation will be challenging as mentioned in the following articles instead service account only might work if possible.
View 3 Replies
View Related
Oct 8, 2007
Hi,
Just upgraded some development desktops to Vista Business. However we need
to still connect to some older remote windows 2000/SQL 2000 servers.
Trying to setup an ODBC system DSN on our Vista Business local desktop we get the
following errors -
-START ERROR WINDOW-
Connection Failed:
SQLState: '01000'
SQL Server Error: 772
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(SECDoClientHandshake()0.
Connection failed:
SQLState: '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security Error
-END ERROR WINDOW-
Any help greatly appreciated as this is stopping us from making
database/table connections etc. We've checked the firewall setup and all is well there.
PS - we can still connect fine using XP or windows 2000 desktops and their
local DSNs.
View 8 Replies
View Related
Jul 20, 2005
Hello,I received the error message below when i'm trying to install SQLServer 2000 standard edition into a Windows 2000 Professionaleworkstation.Error :Microsoft SQL server 2000 Standard Edition server components is notsupported on this operating system. Only client components will beavailable for installation.Any request modification ?Best regards,Thanks
View 1 Replies
View Related
Sep 7, 2007
I've just started getting this EXCEPTION_ACCESS_VIOLATION (0xc0000005) on machines using Windows 2000 sp4 connecting to SQLServer. This is crashing JVMs (multiple Sun versions and BEA also) in the Java VM frame (outside our code). This has just started recently - perhaps with the last set of patches? Has anyone else seen this or know what I could do to get more information? Could this be related to updates to named pipes?
Thanks!
-Brian Temple
View 5 Replies
View Related
Mar 13, 2001
We have a SQL Server 7.0 system in NT 4.0 environment. We upgraded our users to Access 2000 and started to work with this. Now we installed a new
server which is Windows 2000 based and the domain is different from
the SQL servers domain. We then installed Access 2000 on Windows 2000
to use with terminal server. But I noticed that there was a problem
with the program. I then looked at the program which was written on Access 2000 and saw that the tables and views can't be seen. The program runs but
I can't see the views and tables. Another thing is access disconects from SQL Server when I want to see the tables. So what can be the problem.
In one part there is an Access 2000 on Windows 2000 server. On the other part SQL Server 7.0 on Windows NT 4.0. And Access can't see the tables in SQL server.
View 1 Replies
View Related
May 13, 2006
I am trying to install microsoft sql server 2000 enterprise edition on a windows 2000 advance server. I keep getting error message
A previous program installation created pending file operations on the installation machine. You must restart the computer before running . I have restarted machine and no change.
What does error message mean and what is solution?
View 2 Replies
View Related
Jan 3, 2008
Hi-I have a program that I am developing on a laptop, then deploying it on a server.I have the prgram running passing a username and PW in the connection object, but like the idea of using windows authentication MUCH better.I just joined the domain, so I am domain/me for example.If I log into the server, and look at securities, logins and added domain/me to the logins.I then try and set up a sql connection via both visual studio, and sql server magt studio, and get the dreaded "Cannot generate SSPI context" error. Anyone else have this problem? SHOULD V.S. be using domain/me to connect? TIA dan
View 6 Replies
View Related
Jul 25, 2001
Hi,
I have setup a SQL 2000 cluster and the cluster works fine. I have given the SQl cluster a virtual IP address too.
I am unable to connect to the Cluster from a remote machine, using SQL Enterprise Manager or SQL Query Analyzer.
But I could connect to it from the machines involved in the CLuster.
Someone plese show some direction on this.
Thanks,
Manoj
View 2 Replies
View Related
Nov 25, 2004
Dear Friends
Can I install SQL Server 2000 on Windows 2000 Professional, I have tried but message was "this platform is not supported" and only client components will be installed after installing, I was unable to create any database.
Please help me.
View 7 Replies
View Related
Nov 26, 2007
Can SQL Server 2000 Enterprise Edition (32-bit) be installed on a Windows 2003 Server R2 SP2 64-bit clustered system?
I have the Windows Cluster fully patched, but when I try to install SQL server 2000 Ent Ed (32-bit) from the directory 'd:englishsql2000entx86setupsetupsql.exe' it hangs after I enter the virtual server IP.
NB. I have successfully installed SQL 2000 Ent Ed (32-bit) on a clustered Windows 2003 Server (NOT R2)
Any help or pointers would be greatly appriciated.
View 5 Replies
View Related
May 25, 2001
We just moved the back end of an Access db to an SQL server and upgraded to Access 2000. A strange problem has arisen. The execution of a query in a certain function seems to be causing the function to prematurely terminate (that is, the query does not complete, and the function does not execute beyond the execution of the query). This error occurs only on workstations loaded with Windows 98. Windows 2000 users are unaffected, and the function runs uninterrupted. The query in question contains date parameters. On the SQL server, dates are enclosed in single quotes (')'s, whereas in Access they are enclosed in pound signs (#)'s. When a query is sent by Access to the SQL server, it is filtered through a program that converts the Access format to SQL-friendly code. Our theory is that this process fails to occur on the machines running Windows 98. Does anyone know why this is occuring?
View 2 Replies
View Related
Sep 6, 2004
Hi,
1)can someone help to explain these 2 lines of codes to me?
I need to change this 2 lines of code to my SQL 2000 database that is connected to my computer locally using Windows NT. How can i change these code?Thanks!
char *connectionString = "dsn=SPS;uid=sa;pwd=;";
hr=pRs->Open(queryString,connectionString,adOpenStatic,adLockOptimistic,adCmdUnknown);
From what i know this is connecting to an instance of the server using sa as login and no password. What does the dns refer to ?
2) If i wan to connect to a database located at the server installed on my computer locally using Windows NT authentication , do i use
"strConnection = _T("Driver={SQL Server};Server=MyServerName;"
"Trusted_Connection=no;"
"Database=SPS;Uid=;Pwd=;");"
If not so,how then?Please kindly advice!
View 1 Replies
View Related
Jul 23, 2005
I created a new SQL database using SQL 2000 SP3 on a Windows 2003server. Now when my wed publisher changes his codes in ASP to point tomy new server and SQL database we are getting the message this page cannot be displayed when clicking on the web link. The old SQL databasewas created with SQL 2000 on a Windows 2000 server. Below you will findthe ASP code that we are using. Please Help me!<!--Open Connection to SQL Database--><%'CREATE/OPEN ADO CONNECTION OBJECTDim objConnect, oSurveySet objConnect = Server.CreateObject("ADODB.Connection")oSurvey = "driver={SQL Server};server=SPD-HEAT-01;database=Heat8;" &_"uid=johndoe;pwd=johndoe"objConnect.Open oSurvey,"",""%>
View 1 Replies
View Related
Oct 21, 2006
Is is possible to sync SQL Mobile 2005 with SQL Server 2000 using replication? Or do I need to use SQL Server 2005 or drop back to SQL Server 2000 CE.......
Thanks
View 1 Replies
View Related
Nov 2, 2006
im using sql server 2000 and i m facing this problem plz tell me why is this"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
View 5 Replies
View Related
Feb 11, 2007
Hi all,
I'm having a frustrating time connection to SQL 2000 from the web.config. I'm getting the following error
Here is my config
<?xml version="1.0"?><configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <appSettings/> <connectionStrings> <add name="ConnectionString" connectionString="Server=xxxx;Database=xxx;uid=xxx;pwd=xxx;" providerName="System.Data.SqlClient" /> </connectionStrings> <system.web> <compilation debug="true" strict="false" explicit="true"/> <authentication mode="Windows"/> </system.web></configuration>
This is the error i get
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Any thoughts?
Thanks.
View 3 Replies
View Related
May 22, 2007
Hi there,
I have 2 servers on our compny'ssql server does not exist or access denied lan, one with fixed ip and the other one with internal ip. I installed SQL server 2000 on the one with internal ip and I want to access it from the other server. when I want to register sql server instanse , I can see the name of that instance in the list but I can't register it. I keep reciving this error : sql server does not exist or access denied!
Could any one told me what to do?
View 2 Replies
View Related
Aug 12, 2007
I am using Visual Studio 2005 with SQL Server 2000. I'm having an issue where I can build my website just fine for long periods of time, and then for what appears to be no reason, my site errors out when trying to connect to the database with the message below -- the thing is I don't want to use a SQL Server 2005 database, nor do I have Server 2005 or Server Express loaded. How can I unhook this and make it use SQL 2000?"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) "
View 5 Replies
View Related
Sep 11, 2007
I am trying to connect to a sql 2k database using a Microsoft Application block. I get the following error. It is saying about 2005, I verified that SQL 2K is running on the server.
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings
Any help will be appreciated.
View 5 Replies
View Related
Dec 23, 2005
Hi
I am running Visual Studio 2005 Visual Web Developer Standard Edition on a machine with SQL Server 2000. Could you please teach me how to modify the connection string below so that it connects to SQL Server 2000 with the database called "VisualWebDev".
Thank you.
Jim
<connectionStrings>
<add name="Personal" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>
</connectionStrings>
View 12 Replies
View Related
Jan 28, 2005
Hi, i need to build some way of connecting Oracle to SQL Server in order to pull data off Oracle and house it temporarily on SQL 2000 for searching.
Basically we've built an intranet using ASP and SQL 2000 and which also pulls data off Oracle, however our connection to Oracle is very slow so an idea to speed it up would be to have SQL store a temporary snapshot of this data and the ASP site query off the fast connection it has to SQL rather than use our slow connection to Oracle.
This temporary snapshot of Oracle data would be stored on SQL 2000 and updated on a scheduled basis.
Any ideas how to do this, or a better way to work this?
Thing is I tried installing the Official Oracle ODBC & Client software on our SQL 2000 server before and it just took out SQL 2000 so would really like to hear other options.
Thanks in advance,
:confused:
View 2 Replies
View Related
Mar 19, 2008
I have been using Access 2000 for quite some time and am trying move the application to use SQL Server 2005 Express. Is there any way to connect directly to an Access MDB using SQL Server 2005 Express, or can it only connect to an MDF?
View 3 Replies
View Related
