Cannot Connect To A New Installed SQL Server 2000
Mar 1, 2006
I have installed an SQL Server 2000 Developer Edition (SP4) on a
computer that has Windows Server 2003 on it.The server is connected to
the workgroup "WORK" and has no Active Directory. Now I cannot connect
to that database server from other computers in the network. On the
server itself, I can registrate the instance from the own SQL Server
2000 and also an instance from an other SQL Server 2000 installation on
a Windows 2000 Server in the network.
The network consists of a Windows 2000 Server (with a SQL Server 2000
installation), some workstations (W2000 Pro, Win XP Pro) and the new
installed Windows Server 2003.
When I try to connect to that new database Server with Query Analyzer
from an other computer I get allways the message box with the text like
"...SQL Server doesnt exist or access denied. ConnectionOpen
(Connect())..."
Many thanks for help.
bitchanger
View 1 Replies
ADVERTISEMENT
Aug 31, 2006
Hi
I have another question now.
As the topic said, my sql server 2000 installed on windows xp sp2, the computer's name is "ADMIN" and the server 2000's name is "ADMIN".
When i startup the sql server 2000, it just listening on shared memory and name pipes, not including the "TCP/IP" . So i can not connect to the sql server using the port 1433.
Some people said that the reason was the system's firewall. I also found some supports on the websites 'www.support.microsoft.com'. It said that you can set the port 1433 or the sqlservr.exe to the execption. I also do that, but still not works.
Is there any things i forget and how can i solve the problems! Thanks for advances.
View 11 Replies
View Related
Apr 8, 2008
I have about 4 SQL servers that have SQL2005 as the default instance and SQL2000 as a second instance. My problem is that I can not connect to the SQL2000 instances using the instance name. I can get to it using IP address and port number or if I set up an alias with IP and port number, but not by name (ie ServerNameSQL2000 which is how the instance was named). If the process is reversed (install SQL 2000 first and then SQL 2005) I can get to both instances using instance name.
I read something about if SQL2005 Browser service is running when SQL2000 service starts, the SQL2000 service won't listen for calls, but it was rather vague and I am not real sure if that is true. I am in the process of trying to test this to see if it is true, but due to the nature of the servers, I have to follow a process and it will take me a couple of days before I can test.
So I was hoping to find someone to deny or confirm this. Or who has had a similar issue and can shed some light on this for me. Thank you for you time. I appreciate it.
Jim Youmans
St Louis, MO
View 5 Replies
View Related
Jun 21, 2007
All --
Please help.
Is it possible to connect to MDF file without having SQL Server 2005 Express installed on the machine?
That is-- can one connect directly to an MDF in the same way and Access MDB file can be used?
If no, then is there any way around this?
If yes, then are there any limitations?
Please advise.
Thank you.
-- Mark Kamoski
View 1 Replies
View Related
Apr 11, 2008
I am new to SQL server 2005
Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.
I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):
These are two things that I need to facilitate:
1) They want to be able to write queries using Query Designer and run from their PCs.
2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.
3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.
Any suggestions are appreciated, especially with item number 1.
View 9 Replies
View Related
Feb 11, 2005
Hi, im trying to connect to my sql server installed in windows 2003 OS, i always get login failed whenever i run my asp.net application, do i have to setup anything in my local computer to access my database in windows 2003 server? or in IIS maybe? pls help.
View 1 Replies
View Related
Apr 23, 2008
Hello,
I am creating a windows application that is not going to be used in a controlled environment like a LAN or some other network, so I want to include a local database in the install of this app. Ideally, I would like to use SQL 2005 Express like you would MSDE or Access, but I am not sure if the user must have SQL Server installed on their machine in order for this to work and I don't have a machine without it to test on.
Any help on this is greatly appreciated.
Thanks,
Derek
View 1 Replies
View Related
Mar 28, 2008
Hi,
How can I tell if SQL Server 2000 is installed on my local machine ? I have Enterprise Manager and Query Analyzer installed, are they part of the server install ?
Thanks,
J.
View 1 Replies
View Related
Oct 11, 2007
Hi All!
In my computer I have Installed MS SQL Server 2005(Default Instance) & MS SQL Server 2000(Duynnh Instance). When I write an ASP.NET app to connect to SQL Server 2005 it's OK but not connect in SQL Server 2000. Please give me the SQL Connection string to connect to SQL Server 2000.
When I open Query analyzer connection is OK for both.
Thanks.
View 2 Replies
View Related
Sep 21, 2004
I am facing a problem with Convert function in SQL server 2000 with sp3 installed , Japanese version
In sql server 2000 (sp1 installed) Japanese version, the convert(datetime,,111) gives me date in the format yyyy-mm-dd hh:min:sec
But in sql server 2000 (sp3 instaled) Japanese version, the convert(datetime, ,111) gives me date in the format yyyy-mm-dd.
I need the hh:min:sec to do an exact date comparison.
The problem is solved if I use Convert(datetime,,120).
Any pointers on the root cause of why the problem occurs with convert() function once sp3 is installed?
View 1 Replies
View Related
Jul 20, 2005
Hello,I am having trouble installing Evaluation copy of SQL Server on mynotebook, which has XP, P4 processor,1G Ram, and 14 G harddisk space.After I run the Setup.exe, I get the files files extracted in theSQLEVAL directory.As per the instruction, I need to run Autorun.exe file. For somereason, when I try to run this file, a new windows pops up, which isblank black screen with cursor flying around in the window. The titleof the window isC:windowssystem32wowexec.exeThis is how far I have reached while trying to install the database. Iwould really appreciate if someone could provide some suggestions.VS
View 2 Replies
View Related
Jul 20, 2005
We have just installed a SQL Server 2000 (SP 3A) onto a computer thathas Windows-2003 Server on it. Now, we cannot get access to thatdatabase server from other computers. Seem like this may be an issuewith Active Directory.Our network consists of Windows-2000 Servers (SP 4) and Windows-2000workstations and Windows-XP workstations. We also have SQL Server 2000(SP2) in three Windows-2000 servers. All work fine. Recently, we get anew server that has already had Windows-2003 Server pre-installed.After we have installed SQL Server 2000 (SP 3A) on the new server, wefind that we cannot get access to that new database server from othercomputers.I have tried connecting to that new database server using QueryAnalyzer (using both the sa account and Windows Authentication), and Iget this error message:Unable to connect to server NEWDBSRV:Server: Msg 17, Level 16, State 1[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does notexist or access denied.I have tried connecting to that new database server using ISQL (usingboth the sa account and Windows Authentication), and I get this errormessage:DB-Library: Unable to connect: SQL Server is unavailable or does notexist.Unable to connect: SQL Server does not exist or network accessdenied.Net-Library error 53: ConnectionOpen (Connect()).I have also tried to register the new database server using EnterpriseManager (again, using both the sa account and Windows Authentication),and I get this error message:NEWDBSRV - SQL Server does not exist or access denied.ConnectionOpen(Connect())The only way that I can get access to the new database server is toopen Enterprise Manager directly on the new server.I have compared the properties of the new database server and those ofthe other existing database servers. The only differences are:-Other database servers are running Windows-2000. The new databaseserver is running Windows-2003.-The new database server is missing the "Active Directory" page-tagwhen I check its properties using Enterprise Manager. We use ActiveDirectory in our network, and the Active Directory is being run from aWindows-2000 server (that is currently also a database server).According to our network administrator, he has already put the newserver into our Active Directory. He doesn't know why it is missingthe Active Directory page-tag. He believes this has something to dowith its having Windows-2003 that is different from other servers(that have Windows-2000).Thanks in advance for any info.Jay Chan
View 2 Replies
View Related
Oct 17, 2007
hi there,
we have sql server 2000 installed on win server 2003 and now i want to install a fresh copy of sql server 2005 on the same machine without disturbing the existing state.
is it possible or is there any chance of system/sql server malfunction
suggestions please..
..gcnivas
View 1 Replies
View Related
Nov 26, 2006
hi there - I'm praying someone here can shed some light on this - after many google and web searches, I have found users with similar issues, but have yet to find a solution.
Problem: I have recently upgraded my desktop from Windows XP to Windows Vista Ultimate (clean install) and have migrated my local machine to SQL Server 2005. However I have a number of .Net projects that access databased on another server running SQL Server 2000 - prior to my upgrade to Vista, I was running SQL Server 2000 on my desktop as well. During the install, everything seemed to go well, and I also installed the SQL Server 2005 Service pack as instructed via the MSDN site. However, when attempting to test my .net projects on my desktop pc (ie visit http://localhost), I encounter the error:
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)
note that the server I am attempting to connect TO is the old SQL 2000 server - NOT 2005. I specify my connection info in the web.config - and it points to an external ip address on the web.
Can anyone shed some light on this? I've tried enabling remote access on my local SQL 2005 install, but I'm fairly sure thats for servers that want to connect to my desktop, rather than my desktop attempting to connect to external servers. Any help is greatly appreciated - I'm pulling my hair out over trying to figure this out! :)
To summarize my setup (if it helps)
Desktop PC:Windows Vista (Ultimate)SQL Server 2005Visual Studio 2005II 7.0.Net 2.0 (ASP.Net Application)
External Server (co-located at a datacenter)Windows Server 2003SQL Server 2000IIS 6.0.Net 2.0 (ASP.Net Application)
Much appreciated,
Ted
View 5 Replies
View Related
Feb 25, 2004
I need to populate a Public Contacts Folder on an Exchange Server with data in a SQL 2000 Table. What would be the best way to do this?
Thanks
View 1 Replies
View Related
Jun 27, 2006
Hi all,
I have to deal with a private network of laptops which are all equiped with preinstalled "Windows XP home"
I've installed SQLExpress on one of these, but I cannot connect on it from the rest of the laptops. (I've successfuly done this with "Windows XP profesional" though, and local connections work fine as well).
I've already setup the SQLExpress to accept conections throuigh TCP/IP but I can not think of something else. (Security comes to mind, but I do not know how to resolve it on "Windows XP Home").
Thank you
Ioannis
View 6 Replies
View Related
Jul 20, 2007
I want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.
View 5 Replies
View Related
Aug 17, 2006
hi everybody, i got this error in my code.
Server Error in '/' Application.
SQL Server does not exist or access denied.
Source Error:
Line 12: Dim SQLConn As SqlConnection = New SqlConnection()Line 13: SQLConn.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")Line 14: SQLConn.Open()Line 15: Line 16: cmdLath = New SqlCommand ( _
my web.config
<configuration>
<appSettings>
<add
key="ConnectionString" value="Data
Source=xxx;UID=xxx;pwd=xxx" />
<add
key="ConnectionString" value="Server=xxx.xxx.x.x;database=xxx;UID=xxx;pwd=xxx;Trusted_Connection=True"
/>
</appSettings>
<system.web>
<sessionState cookieless="false" timeout="20"
/>
<customErrors
mode="Off"/>
</system.web>
</configuration>
what seems to be a problem, please help me??????
View 6 Replies
View Related
Feb 25, 2008
hi i have sql server 2000 installed on my domain server machine. Now i want to connect to that instance from another client machine.thanx in advance
View 3 Replies
View Related
May 12, 2006
I installed sql server 2000 on a remote server. I can connect to
it from the client with query analyzer, but I cannot connect to it from
ASP.NET. I'm using Sql authentication, and the account has every
permission under the sun. I can also connect to it from the
server explorer in visual studio.net. I turned off the
firewall. I tried connecting with the same asp.net code from a
different computer and still no luck. I've triple-double-checked
the connectionstring. It's the same credentials I'm using for
query analyzer and server explorer, which both work fine. Any
troubleshooting tips would be GREATLY appreciated.
Thank you.
View 2 Replies
View Related
Aug 13, 2004
I can't connect my jsp file to SQL Server 2000. Below is my code and the error result that i got.. Please help me to solve it..I have installed the driver and write them in the classpath..
<%@page import="java.sql.*"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
try {
// Open Database connection
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://sansan:1433;databasename= coffeepassion","sa","sa");
// Query Database (all queries use the same connection)
String sql = "SELECT EmpID, EmpPassword FROM EmpLogin";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("sql");
// Print header and each record returned
out.println("List of items in the database:");
while(rs.next())
out.println(rs.getString("EmpID") + " " +rs.getString("EmpPassword"));
// Finished using the database instances
rs.close();
stmt.close();
con.close();
}
catch (Exception e) {
out.println(e.toString()); // Error message to display
}
%>
Error Result:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open database requested in login ' coffeepassion'. Login fails.
View 2 Replies
View Related
Jan 26, 2006
I have SQL server 2000 installed on machine A and when I try to connect using machine B, I get the error message:
A connection could not be established to "servername"
Reson: Timeout expired.
I have been able to connect to the machine in the past and this morning, the server was rebooted and now I can't connect. I can see the server using enterprise manager and I can start and stop machine A from B, but I just can't connect. Any ideas?
Thanks
View 1 Replies
View Related
Jan 26, 2006
Hello masters,
help me yaar
i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me
gs
View 31 Replies
View Related
Dec 8, 2006
i want to connect SQL Server 2000 with remotely how it will work?
i have a sql server data base on server(domain) in xyz company, they give me following information:
database name
server IP address
database user name
database password
i can connect the same database using networking internet (proxy)
connect internet connection
start proxy connection
i am using a pc from network which is useing proxy for internet.
i open query analyzer
enter IP address, user name and password (which is currect)
though i can't connect sql server
else i can connect the same server which PC is using own internet connection not form network
i want to know that
how can we connect SQL Server using internet connection form network (proxy server)?
where is to enter networ pc IP address?
where is to enter port number?
View 3 Replies
View Related
Apr 3, 2008
Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
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 SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
View 4 Replies
View Related
Apr 28, 2007
Running ASP.NET 2.0 on a Windows SBS2000 with IIS5 and SQLServer 2000 on the same box.
Trying to use membership controls to authenticate.
Installed aspnetdb on the server using aspnet_regsql.exe
Ran an ASPX page with the asp:CreateUserWizard control.
The "create user" button returns the following error:
A user instance was requested in the connection string but the server specified does not support this option
I appears that the connection string I am using is wrong.(See below for web.config entries)
I have tried:
"data source=RGMILLSITES;Integrated Security=True;database=aspnetdb;User Instance=True""data source=RGMILLSITES;Integrated Security=True;database=aspnetdb;User Instance=False""data source=RGMILLSITES;Integrated Security=True;database=aspnetdb""data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb;User Instance=False""data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb"
I have renamed LocalSqlServer to LocalSqlServerASPNETDB to ensure that a global configuration is not used.
I tried to rename the server in the connection string and got the same error"data source=RGMILLSITES00;Integrated Security=True;Initial Catalog=aspnetdb"
I've checked the Machine.config and web.config in the C:WINNTMicrosoft.NETFrameworkv2.0.50727CONFIG folderNeither have the LocalSqlServerASPNETDB configuration listed.
So now I'm thinking there is a cashing isssue. I've tried to restart the site and got the same result.
Any thoughts would be appreciated.
RobGMiller
The web.config file contains the following related skeema.
<connectionStrings> <add name="LocalSqlServerASPNETDB" connectionString="data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb;User Instance=False" ProviderName="System.Data.SqlClient" /></connectionStrings>
<roleManager enabled="true" defaultProvider="CustomizedRoleProvider"> <providers> <add name="CustomizedRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="LocalSqlServerASPNETDB" /> </providers></roleManager>
<membership defaultProvider="CustomizedProvider"> <providers> <add name="CustomizedProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="LocalSqlServerASPNETDB" applicationName="/" minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0"/> </providers></membership>
View 2 Replies
View Related
Mar 5, 2008
Hi,I want to install an asp.net app on a sql server 2000.I've created a virtual Directory which points to the folder C:WINDOWSMicrosoft.NETFrameworkv2.0.50727ASP.NETWebAdminFiles.I've installed my website under InetpubwwwrootIn Web.config I changed the Connection String to point to my local server <connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=MY_DB;Integrated Security=True;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> </connectionStrings> I'm connecting to: http://localhost/ASP.NETWebAdminFiles/default.aspx?applicationPhysicalPath=XXX&applicationUrl=/YYY and I seeWelcome to the Web Site Administration Tool Application:/MyAppCurrent User Name:ComputerNameLoggedUserIf I click the Security Link, I get the following error:The following message may help in diagnosing the problem: Cannot open database requested in login 'MY_DB'. Login fails. Login failed for user 'MACHINE_NAMEASPNET'. What I missed to configure in order to be able to create Users and Roles in the security app? Thanks
View 1 Replies
View Related
Apr 30, 2005
Hi!I am going to connect to "SQL Server 2000" through an "ASP.NET Web Application". My development environment is "Visual Studio .NET 2003". In my "Toolbox" -> "Data", I drag a "SqlConnection" and drop on the page. It would automatically be named "SqlConnection1". In its "Properties" -> "ConnectionString" -> "<New Connection...>", I would enter my Server Name (SAMIEI), select "Use Windows NT Integrated Security" and Select the Database on the Server (Northwind). Then such Connection String would automatically be generated:
"workstation id=SAMIEI;packet size=4096;integrated security=SSPI;data source=SAMIEI;persist security info=False;initial catalog=Northwind"
Now, I may see "SAMIEI.Northwind.dbo" in the "Data Connections" row of "Server Explorer" with its all "Database Diagrams", "Tables", "Views", "Stored Procedures" and "Functions".Please take a look at the following code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try SqlConnection1.Open() Catch ex As SqlException Response.Write(ex.Message) End Try
End Sub
It would unexceptedly encounter such error:
"Login failed for user 'NT AUTHORITYNETWORK SERVICE'"
Please tell me the reason. I am much obliged to you for your attention.
Regards!M.Sadegh Samiei
View 2 Replies
View Related
Jul 25, 2005
I'm Building a windows application which updates an internet site's database.Is it possible to connect directly to the sql server through the internet?If so is it the most efficient way ? perhaps a web service or streaming is a better solution?Thanks.
View 1 Replies
View Related
Jul 23, 2005
I need to connect SQL Server 2000 to DB2 on z/OS through DB2 Connect 8.I can successfully connect and query data through a System DSN, buttrying to link the server using this DSN and MSDASQL fails (can't seemto find the DB2 Connect server). I've also tried IBM's OLE/DB driver(IBMDADB2).Has anyone successfully linked to DB2 on a mainframe through DB2Connect 8.x via either ODBC or OLE/DB drivers?
View 3 Replies
View Related
Sep 4, 2006
I just started to learn Visual Basic 2005.NET. I have experience with VBA in Access and SQL Server.
I
now want to build applications (client/server) with VB & SQL
Server. Does anyone have a simple example with which I can start
learning?
Thank you in advance!
View 4 Replies
View Related
Feb 7, 2008
I just stopped sql server 2000.
Right click server->stop
and closed...when i am trying to connect the server i have a message saying cannot connect.
How to get that back running
thanks
View 7 Replies
View Related
Feb 26, 2006
Why I can't connect sql server 2000 with wm5 or emulator ?
I used windows server 2003, sql server 2000 Enterprie SP4, visual studio 2005.
My this code can connect to sql server with win application (.net framework 2.0) but can't connect to sql server with device application (.net compact framework).
Dim strcon As New SqlConnection("Data Source=192.168.0.3;Initial Catalog=nortwind;User ID=sa")
Try
strcon.Open()
Dim sqlcom As New SqlCommand("select * from products", strcon)
Dim s As String = sqlcom.ExecuteScalar.ToString
Catch ex As Exception
MessageBox.Show(ex.Message.ToString, "")
Finally
strcon.Close()
End Try
Question
1. How to tip for setup and config windows server 2003 and sql server 2000 can connect with device?
2. What's IP of device in running ?
View 23 Replies
View Related
