Dear All,
I am developing a network application in asp.net. The database is in local machine having sql 2005. But the user database is already existent. So I am accessing that database which is sql2000. does it give any problem while connecting from sql2005 machine to sql2000. If yes it is giving me error as follows:
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.)
connection string is :
"Data Source=192.168.1.16,1433;Network Library=DBMSSOCN;Initial Catalog=mycatalog;User ID=myuserid;Password=mypwd;"
Please correct me if I am wrong.
Thanks and Regards.
Fazal
I have installed MSDE2000 (name: mypcsql2000, port 1433) and sql2005 Express (mypcsql2005, port 1434) on my WinXP. I'm developing some application and I need to test both server.
It has worked fine about 1 year, but last month i got error message.
When i'm trying to connect to SQL2005 from my application or import data from Excel, i get error message: [DBNETLIB][ConnectionOpen (Invalid Connection()).]Invalid connection.
I can access SQL2005 with Management Studio or cmd line (sqlcmd). But not with Excel (or with my application).
MSDE2000 works fine, i haven't any problems.
Last weekend I have reinstalled my WinXP and also MSDE2000, SQL2005 Express. Worked fine, but when turn on automatic updates ON and afterwards installed latest updates, the problem is here again...
Sql server type: database engine server name: authentication: sql server authentication login: sa password: xxxxx
I remember the server name being sqlexpress (I think that was the default name during the install).
OR are they asking for my computer name? because I tried that also and it gave me an error saying "the default installation doesn't allow remote connections"
I have an interesting problem. I am running xp pro and when I try to connect to an instance of SQL2005 running on WIN2003 using SQL Sevrer Management Studio, I get the following 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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider)
This instance is protected by a vpn and is running on a clustered environment. I can connect to other SQL2000 servers that are running on a clustered environment and SQL2005 that is not clustered.
After adding a host file entry, I was able to connect to the server using OSQL. I was able to telnet into the port the server is listening on.
Others in my group can connect to the server using SQL Server Management Studio with no problems. They are running Win2003 Server. I originally could connect to this server, but I needed to change my password. After that I lost my remote connectivity. I can RDP into the server and map drives to the server. I map to a local administrator of this machine.
Hi,i have SQL 2000 and 2005 on same machine(with different intance names,of course), my laptop - XP with SP2. The 2005 works fine but i can'tconnect on SQL 2000. All the the SQL services are started.Any idea? Have i to reinstall 2000?Tks,Lourival
According to my technical support for web hosting, for database format they only use "MS SQL" operating on a windows system, usualy clients create they're sites on their local machines using "MS SQL".
I'm just wondering.....
Is 'MS SQL' free? where can I get it?
I also have the option of creating the site round an access databse but I'm worried about the security issues,
do you think it would be wise to use access?
Is it easy to convert a site written in ASP.NET&ACCESS into a site using ASP.NET&"ms sql"?
because then I could code a site in the former on my machine and then change the code to link to an sql server.
I was just trying out Microsoft SQL Server 2000. I created a sample application which reads in 2 values from a textbox and writes it into a databse. This application works fine on my computer and the values are written to the database (In the connection string, I give my IP address as the datasource so that anyone on the internet can hit this database). However, when I copy this application to another computer and try to run it, it gives me an error "SQL Server does not exist or access is denied." I know this is a minor problem with some setting, but I haven't been able to find the solution on the internet. Can someone whose worked with Microsoft SQL Server 2000 please help me out.
Just installed a new version of SQL2005 on a brand new Application Server.
However, when i fired up Access 2003, it gives me some chaos about how Access isn't compatible with SQL2005. Fantastic lack of backward compatibility straight out the box.
Ok, so I do as it says and download all the updates.
Try again... Still won't allow me.
Wen't to Control Panel > Data Sources and confirmed the Native Client is in there. Added a System DSN for the new Server.
Tried Access again, still not working?? What the...
Why can't I create a new project in Access 2003, and edit it from my desktop instead of sitting on the server for every table modification? I hate designing tables on the SQL studio.
Any clues or help would be great. I'm just disappointed at the moment, on how this is holding up my database projects.
I've just started to learn to use Visual Studio, and has come to database access. I ran into this errormessage:
access denied for user <machine name>ASPNET
The book I'm using just only say that I have to grant the ASPNET user account permissions before the Web application will have access to a SQL database. ... Seems clear at first glance ... but I lack a "how to" ...!
---
I've tried to search the net for solutions ... several thousands of pages came up ... indicating that I'm far from the first who have this problem. ... So after I now have spend hours reading, without finding any useful ansver to the question. ...
So let me just tell the most popular answers. (So You don't repeat something I allready have read hundreds of times.): This question has been asked before Yes, true answer, but it doesn't help.
See the FAQ If it was stated were in the FAQ to look it could have been useful.
Use something called "enterprise manager" (WIN XP pro, don't have this, though.) I use WIN XP pro, so that answer dosn't help me either.
Does anyone know how to prevent a certain machine from accessing SQL server? We have users who use a generic username and password (i.e. one login for 15 users) and I need to prevent a certain machine (in a high risk location) from hitting my databases. Any ideas
I have created and deployed an SSRS report, which I am able to access from the same machine using the URL. But I am not able to access the URL from a another machine in the same network.
What could be the problem, do I need to make some configuration changes to the reporting server?
I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.
His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"
However his Access.MDW File is located in the directory "C:Documents and SettingsJoe NobodyApplication DataMicrosoftAccessSystem.MDW".
There is no directory called "C:Documents and SettingsPAVSGP024FE.NWFSC.NOAA.GOVApplication DataMicrosoftAccessSystem.MDW".
He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error
"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"
I dont know what else to try! Anybody have any suggestions?
database has been recently upgraded from ms sql 2000 to ms sql 2005.are there anything I need to be aware after upgrading to ms sql 2005?for my experience, i got an error if i use column alias in ORDER BYclause which was fine on ms sql 200.thanks
I am runing Windows 2003 which has both SQL2000 and SQL2005.
The following works in 2000 but not 20005
Code Snippet DECLARE @sql nvarchar(4000) set @sql = 'sp_addlinkedserver @server = N''dbAccessPO'', @provider = N''Microsoft.Jet.OLEDB.4.0'', @srvproduct = N''OLE DB Provider for Jet'', @datasrc = N''C:Temppopts.mdb''' exec sp_executesql @sql set @sql = 'sp_addlinkedsrvlogin ''dbAccessPO'', FALSE, ''sa'', ''Admin'', NULL' exec sp_executesql @sql
Running this:
Code Snippetselect * from dbAccessPO...MyTable
Produces this error:
Code Snippet OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "dbAccessPO" returned message "Unspecified error". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "dbAccessPO".
I need to move a DB that's on a SQL 7.0 box to a SQL 2000 box for consolidation. I cannot upgrade the 7.0 box to 2000 at this time. I tried reattaching it on the 2000 box and it gave me some errors about versions mismatched. Would DTS be the best way to pull it over? If not, what's the recommended operation?
I'm currently running SQL Server 6.5 and 7.0 together on the samemachine (i.e. switchable using the program switcher). Does anyoneknow if i can install SQL Server 2000 to run alongside both of these?Thanks in anticipation.Rob
Hi i am new using SQL 2005, i have SQL 2000 Personal Edition SP4 with 2 databases for testing installed in the default instance and i would like to install SQL 2005 standart Edition (i have Windows XP pro sp2) . can i have the same instance for both SQL database engine?. or to create a new instance for the 2005?. what i need is to test SQL 2005 while i keep my database for test in SQL 2000. I was trying to install by typing a named instance, and it gave me an errors. then i try again by choosing the default instance and then it start an upgrade operation and affter a sucess upgrade now i cannot see the sql management studio and neder Enterprice Manager for SQL 2000. i am confuse, some ideas for this issue?
We just installed an application, WhatsUpGold, to monitor our servers. Management won't let me host that on my primary SQL box. So, we are using MSDE on the local machine (call that box my_netmon).
I can access the db with very basic functionality using osql while on the my_netmon machine. I've added my domain user account as a System Admin using the following commands.
exec sp_grantlogin @name go
exec sp_addsrvrolemember @name, 'sysadmin'
But when I go to the my_sql machine and try to attach to it with Enterprise Manager I get an error that the server does not exist.
What gives??? Is it just not possible, or am I missing something here?
My goal is to just be able to see the data stored in the MSDE db. Write views, etc...
Hi, I am trying to create a connection string that will connect to a SQL Server 2005 Registration on a remote machine. I have a SQL Server 2000 registration (installed) on the same machine and so I think there may be a conflict. The SQL 2005 registration is denoted as HARDYSQL5 and the 2000 registration is merely HARDY (the machine name). I need to connect to a database on the HARDYSQL5 registration but I am not connecting. I have tried various connection strings but none have worked. I get a Login failure. I think this is red herring because I doubt its even finding the database.I can connect to the 2000 db with:"Server=HARDY;Database=Perimeter;UID=use;pwd=example;" But its fails with the following, for example:"Server=HARDYSQL5;Database=Perimeter;UID=use;pwd=example;" "Server=HARDYSQL5;Database=HARDYSQL5Perimeter;UID=use;pwd=example;" "Server=HARDY;Database=SQL5Perimeter;UID=use;pwd=example;" I'm gon go nuts. What am I doing wrong? Thanks.
Hi all, I'm about to download the VWD ASP.NET 2.0 with SQL Express 2005, but i currently have Visual studio.net 1.1 and SQL Server 2000 installed on my PC, XP Pro. Has anyone had problems with this or are they happy to run along side one another without over writing projects already created in the older versions? Thanks in advance. Allen
i am trying to install SQL 6.5 client on 2000 box. but the installation wants to install an SQL 6.5 SERVER on it. Is there something im forgetting? is there a way and if so how? if not, is there a workaround with out upgrading the sql 6.5 server.
I am moving my SQL 2000 Server from a Small Business Server to a full version of Windows 2000 Server and SQL 2000 Server. I have had no experience doing this but have backed up and restored my production databases for practice in case a of disaster situation. Is there anything special I need to do to move everything, including the system databases to a new server and not loose any of the user logons, etc.?
Is it possible to install sql server enterprise edition on an xp machine (home or professional)? I tried both (w/sp2) and it said it can only be run as a client.
i have SQL Server 2000 running on my notebook for learning purposes. Is it possible to run SQL Server 2005 on the same notebook without using virtual machines?
I'd like to draw on your expertise on this topic. I've been browsing at many blogs/forums about installing SQL Server 2000 and 2005 on the same machine.
What I'd like to know is how does that work with Reporting Services? Your machine's IIS will need to work with Reporting Services 2000 and Reporting Services 2005. The RS 2005 requires .NET Framework 2.0 and RS 2000 requires .NET Framework 1.1. IIS can only support 1 version of the .NET Framework at a time.
