Hi,
I have installed MSDE 2000 and when i am trying to connect to the server from command line using following command -
osql -U sa
It gives error message -
Login failed for user 'sa'
The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.52
Please advise.
Thanks
Abhijeet
Hi,
I'm trying to connect to an instance of MSDE 2000 from Visual Studio 2005 over a home network. Although I know how to connect to a database from Visual Studio, I'm pretty clueless about configuring Sql Server to allow the connection (I can connect with no problem when I do so from the same computer). Also, with experimenting I've created a bunch of instances of Sql Server that I don't really need and am not sure how to get rid of them. Thanks in advance for any help.
-Dave
I don't know if this will help, but I've already tried enabling all of the network protocols in the instance. Also, I can easily connect to an Access database over the network.
G'day,
I'm very new to ASP.NET (but not to programming) and I'm having some trouble with connecting to a database.
I am using C#.NET and I dragged the SqlConnection component onto the form, set the connection string to (local) and to use integrated security, and on that data link properties page I can press the test connection and it works fine, and I can see the databases in "select database on server" drop down box... but when I try and Open() the connection I get a
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'AMD2500ASPNET'.
Can anyone help me?
Thanks,
Robbo
I am trying to connect to a MSDE database on server from my desktop using query analyzer. I keep getting the generic "SQL Server does not exist or access denied'
I have verified the following:
- the login/password is valid because when I access osql from server I can gain access
- the registry for Loginmode appears OK - set to 2 - mixed mode
What else do I need to check...
Thanks, kgaske
Being new to the SQL server world I have a beginner question.How do I grant access to database from a networked computer?I have tried:sp_grantlogin '\computernameusername'and I get the error:Windows NT or user <above> not found. Please check name.Any help would be appreciated.ThanksEric
View 1 Replies View RelatedPlease advise: I have created a simple ASPX page to test if I can connect to MSDE on a Server 2003 system. The connection string that works ok is:
server=WS1;database=northwind;integrated security=false;user id=sa;password=xxx;
but the string that does not work is:
server=WS1;database=northwind;integrated security=SSPI;
which is the string I would like to use for normal web access. This string works fine on my development system (where I use XP Pro and IIS 5.1)
In IIS6 on the "production server" the directory security on the virtual dir is set to allow anonymous access, using user IUSR_WS1 (where WS1 is the name of the system) and to integrated security.
Please help! Thank you
John B
I just installed MSDE and when I try to connect to it I get the following message:"Uable to connect to the database. General network error. Check your network documentation.ConnectionRead (recv()).TDS buffer length too largeTDS buffer length too large"Can anyone tell me how to correct this problem?
View 1 Replies View RelatedHi there, i've installed MSDE and have successfully connected to it from a remote version of Enterprise Manager but when i try to connect using ADO.NET from a website using the same login details i get the following message:"SQL Server does not exist or access denied"I installed msde with DISABLENETWORKPROTOCOLS=0 and SECURITYMODE=SQL so everything should be setup properly. My connection string looks like this:server=ip_addressinstance_name;uid=myusername;pwd=mypassword;database=mydatabaseThis connection string works fine when testing locally (without ip address ie. localhostinstance_name)Any ideas why this doesn't work??
View 2 Replies View RelatedHey guys, I am a newbie here, so please bear with me. I have installed SQL Server 2005 CTP on Machine A and MSDE on Machine B. Both these contain the PUBS database beside others. On Machine C, I have installed "ASP.Net Web Matrix" and I want to be able to connect to either Machine A or B to access the PUBS database. It connects to Machine B, when I put in the Servers IP address. But everytime I try to connect to Machine A, it gives me an error saying, "Unable to connect to the database. To connect to this server you must use SQL Server Management Studio or SQL Server Management objects(SMO) ". I heard that connection strings are needed to access the SQL Server 2005 but I have no idea where to begin. Do I need to create special users to access the Server or will Windows authentication work ? Could anyone help me out in connecting to the SQL Server 2005 CTP?
View 15 Replies View RelatedHi,
I have installed MSDE into my system, in which SQL Server is not installed. I have followed the installation instructions and installed MSDE.
How can i connect to the database? I have the .MDF file of the database (already created in sqlserver) in the Data Folder. How can i connect to the database from Visual Basic 6?
Hello,
I have downloaded WebMatrix/NET.Framework and it works well.
Unfortunatelly I have problem with connecting to MSDE.
I've installed the new version (sql2ksp3a) like they say:
setup.exe INSTANCENAME=my_inst_name DISABLENETWORKPROTOCOLS=0 SAPWD=my_pass
SECURITYMODE=SQL
The MSDE works ok (I can connect from a commercial programs - for example
'MSDE Manager') and seems to be ok.
But when I try to connect from Web Matrix I get the error:
"Unable to connect to database, Invalid connection connection Open, Invalid
instancename".
I put all the parameters correct:
user: sa, auth.type: SQL, server: my_pc_namemy_instance_name
By the way the instance name and my PC name is the same. Could it be the
reason ?
Please help,
greetings to all
Hi,Does anyone know how I can connect to an MSDE db using VB with aread-only file? The file will be on a CD, and is actually just archiveddata off a SQL server. I would like to package my app on a CD alongwith the data file and allow users to pop in the CD and run the app,assuming they already have MSDE running. Any help?Thanks,Jason
View 1 Replies View RelatedHi!
I have installed MSDE 2000 in "Mixed Windows and SQL mode authentication with network access" .following is the command:
setup.exe DISABLENETWORKPROTOCOLS=0 SAPWD="password" INSTANCENAME="TempInstance" SECURITYMODE=SQL
Then I created the database TempDB in it.
When I try to connect this database from my program running on my machine , it works fine. But when i try to connect to it from the same program running on a different machine on the same domain.It gives error:
"SQL Server does not exist or access denied ."
Even when i run the same program in my machine to access the same TempDB database on a remote machine that is not in my domain, it works fine.
this is my connection string:
Data Source={Database server's IP Address}TempInstance;Initial Catalog=TempDB;User ID=sa;PWD=password;
Please help.
KT.
Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies View RelatedMy objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
Ron
venu writes "Hi,
Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI
just i need a clarifications reg same
Thank you,
venu"
Parameter
Access 2000/XP
SQL Server 7.0
SQL Server 2000
MSDE 2000
Number of instances per server
n/a
n/a
16
16
Number of databases per instance / server
n/a
32,767
32,767
32,767
Number of objects per database
32,768
2,147,483,647
2,147,483,647
2,147,483,647
Number of users per database
n/a
16,379
16,379
16,379
Number of roles per database
n/a
16,367
16,367
16,367
Overall size of database (excluding logs)
2 GB
1,048,516 TB
1,048,516 TB
2 GB
Number of columns per table
255
1024
1024
1024
Number of rows per table
limited by storage
limited by storage
limited by storage
limited by storage
Number of bytes per row
(Excluding TEXT/MEMO/IMAGE/OLE)
2 KB
8 KB
8 KB
8 KB
Number of columns per query
255
4,096
4,096
4,096
Number of tables per query
32
256
256
256
Size of procedure / query
64 KB
250 MB
250 MB
250 MB
Number of input params per procedure / query
199
1,024
2,100
2,100
Size of SQL statement / batch
64 KB
64 KB
64 KB
64 KB
Depth of subquery nesting
50
32
32
32
Number of indexes per table
32
250 (1 clustered)
250 (1 clustered)
250 (1 clustered)
Number of columns per index
10
16
16
16
Number of characters per object name
64
128
128
128
Number of concurrent user connections
255
32,767
32,767
5
Will any application developed against SQL Server 2000 Developer
Edition work on an identical platform with only MSDE 2000 installed? I
understand there's a concurrency limit with MSDE 2000 of around 25 (and there's no GUI) but apart
from that, are there any aspects of SQL Server 2000 functionality (from the .NET applicaiton code's point of view) that
are "disabled" in MSDE 2000?
Trying to transfer databases from MSDE to SQL. When I use SQLEnterprise Manager - DTS - import or export, it works for the firstdatabase, but then fails for the others. I select the to and fromdatabases using DTS - Import - 'MS OLE DB Provider for SQL Server',then select 'Copy objects and data between SQL Servers'. It failswith the generic error message: 'Copy objects failed', nothingfurther. I tried to just copy data, and it doesn't work totally. Ontwo databases, it said that it copied everything, but when I go inunder Enterprise manager, some of the tables are incomplete, i.e. nodata, table shows up in the list, but if you try to look at it, itsays that it is missing or empty. Also, one table was not evencopied. In the other two cases, I get errors, does not copy alltables. I get errors, like insert fails, but the column it referencesfor the table does not even exist in that table. Any suggestionswould be appreciated.
View 2 Replies View Relatedi went through the documentation but i was not clear on following, here is the scenario :-
a Central server is having SQL Server 2000
3 Remote Locations :- Each having 4-5 no of computers, connected on a Lan, and on one of the machines MSDE 2000 will be running.
My Questions are :-
1. Can remote locations, update data locally and send changes (say in every one hour) to central server. If yes, then how ??
2. Same way they can receive updates from Central Server on whatever was updated on Centra Server or on the 3 remote locations. If yes, then How ??
any help will be highly appreciable.
I am creating an install program and I'm wondering if there is a
difference between SQL Server 2000 and MSDE 2000? Do they have
different entries in the Registry?
From the documentation that I've read it seems as if they are one and the same.
However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
Thanks
I am about to setup an application server. This app will generate reports and instead of just having a HTML page up, I am considering running dotnetnuke type portal to offer the userbase a better interface for the reports, info, announcement, etc.
Server isn't too bad (2x1.7Ghz Xeon I think, 2GIG RAM) type of setup (may be little more or less). App doesn't require as much resources, but we are planning for the future )
While I have some resource to play with, I also need to make sure I don't load much that may impact the application performance. In my experience, SQL Server 2000 will take a lot of resources even when not used as much. So I am considering MSDE.
I am curious however, WHAT ARE THE MAIN DIFFERENCES BETWEEN SQL 2000 Server Vs MSDE 2000 ?
Beside no Client tool and mostly command line specific command, what else there to convince that I should go for server vs desktop engine?
Now our company has Enterprise license for SQL, so I am not worried about the cost (well a little maybe), but mostly wondering about performance.
If you think of any reason why I go to SQL Server 2000 over MSDE, please let me. Otherwise, I think MSDE in this case is the appropriate RDBMS to go for.
Regards,
Impu
Hi,
How does one install MSSQL 2000 on a machine that's already running MSDE 2000? Do i need to unintstall MSDE, or both can be installed seperately??
Is there a way to simply upgrade MSDE into MSSQL 2000?
Thanks!
Hi There,
I have install msde in one computer and try to register from my sql server, the following error message is coming.
A connection could not be established to Cal-itimilsina (computer in which MSDE IS INSTALLED)
RESON: SQL SERVER DOES NOT EXIST OR ACCESS DENIED
CONNECTIONOPEN(CONNECT())
====
BUT THE MSDE IS RUNNING IN THE CLIENT MACHINE. Could any one please help me
Thanks.
Indra.
Hello all, im new here and do not have no experience with sql. I am trying to install a tax software that I need to run my little business. When I install it gets to a popint that it asks me for my SQL server usernme and password. I remember doing this last year and I reinstalled MSDE and set up a username and password. I seem to not remember what I used, i tried all that I would have but can not get past that step.
I remember adding some lines in the setup,ini file when I installed it last year. Now I can go ahead and reinstall it again and set up a new one, but will the uninstalling and reinstalling of MSDE affect my previous software from last year? Its the same software but I need this years installed.
I have tried using sa as the username and a blank password, with a password and others that I have read up on, still cant log on. Keep getting worng credential screen.
Is there a way to get that info, i doubt it or else it would not be secure, or can I just simply reinstall MSDE?
Many thanks!!
Did anybody tried to use this as a database server? Is there an administration interface somewhere which is free?
Dennis
I'm trying to install this application but i get an errorSetup failed to configure the server. Refer to the server error logs and setup error logs for more information.I'm running Windows XP SP2.Could my SP2 be causing me problems considering I successfully installed it previously.Many thanks
View 1 Replies View RelatedI am not sure if this is the right forum, I already had some one freakout on me in another forum about posting in the wrong place.
Anyway:
I would like to upgrade a machine from SQL 7 to MSDE 2000. I would like to keep the existing database from Altiris Deployment solutions intact. Is this upgrade possible?
Any help would be appreciated
This is my first time using SQL. I installed MSDE 2000 on my desktop and after restarting my PC I see an icon in the startup area MSSQLServer with the server being my T-Tag #.
I am trying to upsize my Access DB to Sqlserver. I am still confused as to where does this server reside? How does this whole thing work?
Also, when I tried to upsize my db I got an overflow error.
Could someone please explain how does this work?
Thanks,
DH
Hi folks!
Ive got here a Windows 2000 Professional PC and want to install the MSDE 2000 (incl. SP3) Desktop Server.
But when i execute the setup.exe the following Error Message will return:
http://www.dorst.de/sql.jpg
Here is the setup.ini
[Options]
TARGETDIR="C:ProgrammeMSDE2000"
DATADIR="C:ProgrammeMSDE2000Daten"
SAPWD="*****"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
Can anyone help?
THX !!!!!
Bye
CdR
I have a client that has a server running Windows 2000 Server. anothercompany has installed MSDE (version unknown) on this server. I need toinstall SQL 2000 on the same server. Will the two coexist peacefully?TiaCruznOz*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedHi,
I only have Framework installed on my machine, and I also installed MSDE 2000 Rel. A, using the following command:
C:MSDERelAsetup.exe SAPWD="myPass" INSTANCENAME="myXP"
I can see that the service for this app is running. Though, I could not connect to it using oSql command like the following:
osql -S(local)myXP -E
or
osql -S(local)myXP -Usa, and supply the password "myPass".
The message was:
[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect()).
Any response would be appreciated.
Subi_I
Hello to everyone.
I'm looking for an help :(
I'ved installed MSDE on a Windows 2000 Pro with this option in Setup.ini :
INSTANCENAME=msde
SECURITYMODE=SQL
SAPWD=<mypassword>
All goes good, and at the end of install process, i restart pc.
When restarting, i logged in , and the icon of MSDE was in the System Tray.
Strange thing, is that the circle in the icon have no red square or green arrow inside, but is empty.
I open the window of MSDE and at Server and Service, was 2 empty fields.
I filled on SERVER with the IP address of my pc
Service Field, continue to be blank :(
When i try to start the MSDE, it tells to me that there's no selected service, so the MSDE can't start.
Have someone some ideas on how to solve this?
Thanks to everyone for help!