MSDE ,SSMSE Connection
May 10, 2006
hi friends,
I'll be thankful if anyone solve this problem.
When i developed my application, i used sql 2000 as a server side DB.
Now my client want to install MSDE instead of SQL 2000.
so i uninstall SQL2000 and installed MSDE .
AS we all know, MSDE doesn't have GUI. So i installed Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP)
(includeing xmlparser,windows installer,.net 2.0).
now i could able to view tables and everything. but i couldn't make the connection. Getting error like "SQL server not found. CMPNAMEMSDERELA"
I used same kind of connection string for SQL 2000. Worked well.here what happened?
Connection String : "Data Source = CMPNAMEMSDERELA;Database =TEST; User id ="xxx; Password =xxxx;"
OS: Windows server 2003.
i used VB.NET to develop the apps. (VS2003). Connecting from Pocket PC.
kindly help me to solve this problem.
(Already i posted this in SQL tools forum. i hope this is the right place to post this question. so posting again.)
Thank u!
View 4 Replies
ADVERTISEMENT
Feb 27, 2008
Hi all,
In my SQL Server Management Studio Express (SSMSE)=>Object Explorer=>Databases, the "NORTHWND" database was screwed up and is deleted completely. But under the same Object Explorer =>Databases, there is a database "C:SSMSE-BookChapter12WINCH12NORTHWND.MDF". I need to use this "NORTHWND" database in the SqlConnection. How can I specify the "Initial Catalog" (or "database") in the New SqlConnection code statement (in the ADO.NET 2.0-VB 2005 Express programming)?
Should it be like the following:
Dim sqlConnection As SqlConnection = New SqlConnction("Data Source=.SQLEXPRESS; Initial Catalog=C:SSMSE-BookChapter12WINCH12NORTHWND; Integrated Security=SSPI;") ? Or what is the right code statement for connecting to it?
Please help and advise.
Thanks in advance,
Scott Chang
View 7 Replies
View Related
Apr 25, 2006
Hi,
I am having problem with remote connection via TCP/IP connection on default port 1433. TCP/IP connection are enabled on the server.
any possible solution ?
See problem below:
TITLE: Connect to Server
------------------------------
Cannot connect to ns1.iandigroupltd.com,1433.
------------------------------
ADDITIONAL INFORMATION:
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.) (Microsoft SQL Server, Error: 10060)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10060&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
View 7 Replies
View Related
Jan 13, 2004
When trying to connect to a local MSDE database using an ASP application I recieve the following error when using integrated security.
con.ConnectionString = "server=HNT1PC0281;database=test;Integrated Security=SSPI"
Login failed for user 'HNT1PC0281ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'HNT1PC0281ASPNET'.
This String work in a C# application, but not ASP using VB.
Source Error:
This occurs on the con.Open() statement
When using a loginname/password I recieve
con = New SqlConnection("Server=HNT1PC0281;uid=sa;pwd=something;database=test")
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Source Error:
Let me know if you have any ideas...
Thanks,
View 1 Replies
View Related
Jan 14, 2004
setup MSDE command:
setup sapwd=19820822
connection test file:
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server">
Sub Page_Load()
Dim strConnection as String = "user id=sa;password=;"
strConnection += "database=northwind;server=solo822;"
strConnection += "Connect Timeout=30"
data_src.text = strConnection
Dim objConnection as New SqlConnection(strConnection)
'now we attempt to open the connection
try
objConnection.Open()
con_open.text="Connection opened successfully.<br />"
objConnection.Close()
con_close.text="Connection closed.<br />"
catch e as Exception
con_open.text="Connection failed to open.<br />"
con_close.text=e.ToString()
end try
end Sub
</script>
<html>
<body>
<h4>Testing the data connection
<asp:label id="data_src" runat="server"/></h4>
<asp:label id="con_open" runat="server"/><br />
<asp:label id="con_close" runat="server"/><br />
</body>
</html>
the displayed error:
Testing the data connection user id=sa;password=;database=northwind;server=solo822;Connect Timeout=30
Connection failed to open.
System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ASP.sql_connection_aspx.Page_Load()
what's up? plz tell me. 3x!!
View 1 Replies
View Related
Oct 31, 2004
I have instal VS Studio and MSDE. For experimental purposes I have not instal office and SQL. I wanted to see if I could connect to the MSDE. But each time I try to connect I receive the error message Access Denied or SQL Server does not exist.
Any help folks.
View 4 Replies
View Related
Nov 2, 2004
I have installed the MSDE that comes with VS NET 2002. For experimental reason's I have decided not to instal SQL and Office XP.
But the problem I have is that anytime I try to connect I receive an exception. The exception message is "No SQL server or Access Denied". I am not too sure if I am not doing something right or I have to instal office or SQL. I have created my database using the visual tools in the VS NET 2002.
Any help will very much be appreciated.
View 2 Replies
View Related
Feb 22, 2005
Hi,
I've just started to learn ASP.net using Scott Mitchell's book:ASP.NET in 24 hours. But i've got a little problem in the database section.
I couldn't connect with a MSDE from webmatrix using sql server authentication even the username and password are correct.
The error message :
"unable to connect to the database server:Login failed for user 'sa'. Reason:not associated with a trusted SQL server connection".
What does it mean? Have any of you ever had this kind of problem?
Thank you for helping me.
Regards,
tom
View 2 Replies
View Related
Mar 10, 2005
Hi,
I installed MSDE and the sample databases with it. They work fine.
Well I am using the server explorer of visaula studio standard 2002. I can see all the sample databases there and connect to them as well.
1.
--------------------------------------------------------------------
Now i created a new database named "testDb" and in a similar fashion i am using windows login thingy.
When i write my connection string in the program now it doesnt work
string connectionStr =@"Server=IMRANNetSDK;" + "Integrated Security=SSPI;" + "Connection Timeout=7;" + "Database=testDB;";
If i replace my Database clause to Northwind it works absolutely fine.
The ERROR it gives is:
Cannot open database requested in login 'testDB'. Login fails. Login failed for user 'IMRANASPNET'.
Why is this happenning? :(.
============================================
2.
-------------------------
How can i configure the MSDE to use the SQL Authentication.
It doesnt allow me to do that?
Thanx Heaps,
Imran
View 2 Replies
View Related
Dec 30, 2004
I am trying to connect to a remote MSDE SQL database. When I set up the odbc connection I get a connection denied error. The SQL server is on a windows 2003 server. Any ideas are greatly appreciated.
Thanks, LinsLo
View 3 Replies
View Related
Jun 26, 2004
For a SQL Server 2000 connection string I usualy use the following format:
server=somewhere.com;uid=sa;password=sa;database=myDB
or:
server=66.33.11.123;uid=sa;password=sa;database=myDB
However, now I am dealing with a remote MSDE database. What is the format to connect to a remote MSDE database? Is it:
server=<IPADDRESS><INSTANCENAME>;uid=sa;password=sa;database=myDB
Where <IPADDRESS> is the Ip address of the remote machine and <INSTANCENAME> is the MSDE instance name. Is this correct? If not, what am I doing wrong?
View 4 Replies
View Related
Jan 5, 2005
Hi;
Installed MSDE on computer by running:
c:setup INSTANCENAME="VSdotNET" SAPWD="PASSWORD" SECURITYMODE=SQL
REBOOTED AND sql SERVER iCON APPEARS on the lower desktop Icon bar, open it and it says:
Server: JOHN Servises: SQL Server Running \JOHN - MSSQLServer
opened a command prompt at c: and
entered osql -S JOHN -U sa -P password
and got the 1> reply on the next line
I typed EXIT
I had downloaded two scripts that create Pubs and Northwind SQL databases. I put them in the C: folder
I Typed at c:osql -E -i instpubs.sql
It created the pubs SQL database for me
I Typed at c:osql -E -i instnwinds.sql
It created the nwinds SQL database for me
I closed the command prompt and
went to the Administrator Tools in the Control Panel
I selected Data OLEDB Selected ADD entered Pubs and used default values for Pubs to create a connection Tested it OK
Then went and ran Visual Studio Net 2003
Checked to see if the pubs and northwind SQL databases where present in the Server Explorer drop down window.
I seleced the connect to database Icon and in it's Data Link Properties
I entered JOHN for server name
pubs for selected database on the server
with Provider as MS OLEDB for SQL Service
the Icon changed to connected.
I entered this in the code for page_load
Dim MyDS As New DataSet
Dim ConnStr As String
Dim SQL As String
ConnStr = "server=(local)C:Program FilesMicrosoft SQL ServerMSSQLData;database=pubs;Trusted_Connection=yes"
SQL = "SELECT * FROM Titles " & _
"SELECT * FROM Publishers"
Dim MySqlConn As New SqlConnection(ConnStr)
Dim MySqlAdapter As New SqlDataAdapter(SQL, ConnStr)
'The SqlDataAdapter will automatically open and
'close the SqlConnection
MySqlAdapter.Fill(MyDS)
But I can not get this to work it errors out on line:
MySQLAdapter.Fill(myDS)
with: [SqlException (0x80131904): Unknown ProviderError Locating Server/Instance Specified ]
System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317
I change ConnStr to this:
ConnStr = "server=(local)data;database=pubs; uid=sa; Pwd=password" & _
"Trusted_Connection=true"
and get this error:
[SqlException (0x80131904): Shared Memory Provider: The system cannot find the file specified.
]
System.Data.ProviderBase.DbConnectionPool.GetConnection(Object owningObject) +317
I've tried so many combination with and without user and password, I just don't get it, spent three long days stuck here, can someone help me out.
Note:
C:Program FilesMicrosoft SQL ServerMSSQLData
Is the accual location on my machine that pubs database is located.
I can use the pubs SQL database in Web Matrix OK.
Thanks
pdqjohnny@hotmail.com
View 2 Replies
View Related
Jul 29, 2004
The connection string I'm currently using for SQL Server is Provider=SQLOLEDB;Server=SERVERVSDOTNET;Database= CCDDbase;Integrated Security=SSPI
would this be the same query string for MSDE database? I'm quite new in MSDE but I know that except for the tools that comes with SQL Server and its size, they are practically the same...
View 2 Replies
View Related
May 1, 2007
Hi all,
I installed a MSDE on a Windows XP SP2 and configured it for accepting remote connections. But It shows the "SQL Server doesnot exist or connection denied" message whenever I try to connect to this server. For more information I am adding more facts
* It is an MSDE and not a WMSDE
* Firewall is turned off
* Server process is listening on 0.0.0.0:1433
* TCP/IP and Named Pipes are enabled using server network utility
* LoginMode=2 is set for mixed mode authentication in the registry
* Tried restaring the Process and even windows after the changes.
Please help me !!
Thanks in advance
View 1 Replies
View Related
Sep 22, 2004
i have msde 2000 running on a server i am able to create an odbc connection to my db on that pc. when i try to create anpther odbc connection on another pc on that network i get the following error:
sql state '01000'
server error 2
[microsoft][odbc sql server driver][named pipes] connectionopen (connect()).
connection failed
sql state '08001'
server error 17
[microsoft][odbc sql server driver][named pipes]server does not exist or access denied.
what do i have to do to get this odbc connection on this pc working?
Thank You,
Thomas
View 2 Replies
View Related
Nov 8, 2006
I have just done an in-place upgrade from MSDE to SQL Express with Advance Services for my customer. After upgrading, the program was not enable to connect to SQL Express and threw an error (the program connect to the server through OLEDB provider)
Code -2147217843 (80040e4d) - IDispatch error #3149 - Source : Microsoft OLE DB Provider for SQL Server
It only works if I replace the string "Provider=SQLOLEDB.1" with "Provider=SQLNCLI.1". I wonder why I have to do that because in my working PC and other customers, I don't get this.
The customer's PC use Windows 2003 Server for Small Business Server SP1
Thanks in advance
Huy Le
View 4 Replies
View Related
Dec 1, 2003
I have Installed MSDE SP3a (sql2kdesksp3.exe) on a Windows 2003 Web Edition Server.
The security mode is win/sql. I can log in with both Win NT and SQL security localy, from both EM and MSDE manager.
(in the end of the installation, no dialog show, and the agent does not start automaticly, started on restart)
The MSDE is installed from cmd, with no SAPWD but SecurityMode=SQL.
But from another client on the network (same domain), I can´t connect. I get the "SQL Server Does Not Exist or Access Denied" Error Message
I have check the regestry for the tcpip port settings. And its not 0.
I have read some other MSDE related threads, but no luck.
Any hints what to check new, to try to solve this problem ?
peace.
View 3 Replies
View Related
May 22, 2004
Hi All
I installed the following in order:
1. .NET Framework Version 1.1 Redistributable
2. .NET Framework Version 1.1 Software Development Kit (SDK)
3. MSDE 2000 Rel A
In the command window I changed to the directory where MSDE 2000 Rel A was installed and typed in this:
setup.exe INSTANCENAME=MyDb DISABLENETWORKPROTOCOLS=1 SAPWD=<My SA PASSWORD>
MSDE installed successfully and the little icon appeared in the system tray, next to the clock. However, there was no little green arrow/triangle showing on the icon to show connection status as Connected.
4. ASP.NET Commerce Starter Kit
During the Starter Kit install a Connect to Database window opened - Connect to SQL or MSDE.
In the 'Server' field the following was automatically displayed:
STEVE-HOME/MyDb
Where STEVE-HOME is the name of my computer (changed from 'localhost') and MyDb is the instance name.
Thw 'Windows Authentication' radio button was selected by default. I left this unchanged, then clicked OK.
A window opened asking to test the connection. I clicked OK and the connection was successful.
(I didn't select the SQL Server authentication or enter a username, password or select a Database.)
The Starter Kit installed successfully and works fine. However, the SQL Server Service Manager icon states it is not connected when I mouse over it.
I opened the SQL Server Service Manager window and the Server and Services fields are blank.
Surely the Starter Kit wouldn't work if MSDE wasn't connected.
Can anyone advise on how to get the icon to show it is connected
Your help would be greatly appreciated.
View 1 Replies
View Related
Feb 17, 2006
Getting ready for a system deployment tomorrow and looked at the Teratrax Management tool instead of the Microsoft SQL Server Management Studio Express (SSMSE). Teratrax tool is nice (adds more features for scripting and file management) but thought we'd opt to stick with the free SSMSE for now.
Went to run SSMSE and it doesn't run. Pointer flickers once and then nothing happens. Okay, uninstalled Teratrax and tried SSMSE. No change. Uninstalled and re-installed SSMSE, followed by a reboot. No change.
Argh! Does anybody have any suggestions on what to look for to get SSMSE back in gear? It make life much easier for the green admin like myself and we need it for the interim.
Daggumit, frustrating!
Thanks in advance of any advice or input provided.
Mmmmmkay. Yeah, did you get the memo about the TPS reports?
View 1 Replies
View Related
Apr 25, 2006
Is SSMSE Redistributable?
View 1 Replies
View Related
May 31, 2007
can anyone tell me how to open/create a SQL Server 2005 Compact Edition database using SQL Server Management Studio Express?
cheers
View 5 Replies
View Related
Apr 18, 2008
Hello. I just started using SQL Server Management Studio Express. I am creating a new table by right-clicking the "Tables" folder and selecting "New Table". Then i hit F4 to bring up the "Properties" (because I want to associate a Schema to the table, but when the "Properties" section appears, it's blank. I can't figure out a way to get anything to appear there. Any ideas? Thanks!...
View 2 Replies
View Related
Feb 18, 2006
I have installed SQL Server 2k5 Express on my local machine. I also installed SSMSE on my local machine. When I try to launch SSMSE and connect to the SSExpress I get an error indicating that SSExpress is not configured to accept remote connections. Huh? Everything is local...I'm confused and frustrated. Any help is profusely appreciated.
Thank you
Zach
View 2 Replies
View Related
Jan 23, 2007
What's the difference between "SQL Server Management Studio" and "SQL Server Management Studio Express"? Is there any link to explain this?
Thanks,
Canada DBA
View 4 Replies
View Related
Jun 2, 2007
Using
SQL Server Express with advanced Services
Visual Web Developer 2005 Express
Microsoft Visual C# 2005 Express
SQL Server Management Studio Express
.NET 2
ASP.NET
Problem
After using SSMSE on an IIS ASP.NET database created with VWD this error starts.
"Cannot open user default database. Login failed.
Login failed for user 'machinenameASPNET'. "
If I never use SSMSE, I never have a problem.
I have tried every single suggestion I could find and none of them solve the problem.
Luckily, I am only in the development stages so at least I'm not loosing data.
Development Path
Create VWD Project
Create Database and Tables
Write WebService for DB access
Create C# Project
Connect to WebService
Write project code
Use SSMSE
Attach Database
Do non-admin fuctions on the database(I only opened it to get the auto-generated code for sql statements such as creating Columns so I could do it on the fly)
Detach Database - Check mark the Close Connections
Back to the C# Project
Run the code.
Cannot open user default database. Login failed.Login failed for user 'machinenameASPNET'.
What is SSMSE doing to the database that the web service can no longer log into it?
From VWD you can still connect from the Database Tab.
I finally got so fustrated I just got the SQL Code to create the tables and made a function to create them
after I delete and recreate the database.
View 6 Replies
View Related
Apr 10, 2007
When I used Enterprise Manager it was very easy to import required tables from another server into my local MSDE server.
Now I am using SQL Express and SSMSE I cannot seem to find any other way of importing data other than creating the insert scripts manually which is a very painful and tediuos operation!
Can anyone advise if I have missed something and there is a way to import easily using SSMSE?
Thanks.......in hope
View 6 Replies
View Related
Feb 9, 2007
I've got a database on a shared server at www.dhosting.com
When I fire up management studio express providing the necessary info and hit connect, I get a nice error saying sql server is not able to accept remote connections by default. I ask dhosting support for a few hours. Chris gets back to me every 10 minutes or so. We then finally notice I'm running Vista. I go to my friend's xp. Fire up SSMSE and provide the exact same info and viola, works perfectly.
The xp and Vista machines both are running avast free edition and window firewall. In Vista, I've tried disabling windows firewall, nothing helps. XP handles it perfectly without any problems.
Any ideas?
View 1 Replies
View Related
Aug 6, 2007
Hi all,
I've been running SQL Server 2005 for over three months, and have got the database up to speed. Using SSMSE for an interface.
I've have been trying to get the Intranet to link to the database (ASP), but after a little research i found we needed to change the Authentication from 'Windows Authentication' to a mix of windows auth and sql login. Needing to restart the server for the changes to take effect.
After the restart things started to go pear shaped.
Before the restart we were able to run queries from different clients at the same time (4 workstations). Now we are unable to access anything on the database if a query is running on a seperate client. As in table properties, running a query. As i've said, we were able to do this perfectly fine before the restart.
We also use other programs to generate records for the database. These programs now have difficulty connecting to the database. We've gone through the wizards and as far as we are aware things should be working. We have created extra username/logins for these programs so not one computer/client/program uses the same connection login. However, they are unable to connect even after the wizard says there is no problem connecting to the server.
Is there any *restore to factory/default settings* button? We've even tried reverting to Windows Authentication to try and solve the problem, but it didn't work, we're pretty dependant on the database for day to day operations.
Anyone with an idea as to what's wrong?
Thanks in advance
Gary.
View 3 Replies
View Related
May 2, 2008
Hey guys, I am new to the SQL server scene and I am having some trouble connecting to a remote SQL Server with SQL Server Management Studio Express. I have the username, password, IP address, and port necessary to log in but am apparently not plugging them into the correct places. Can anyone at all point me in the right direction or somewhere that I might at least find the answer? I appreciate any help that can be provided.
Thanks a bunch,
Gary
View 4 Replies
View Related
Aug 21, 2006
I'm new to SQL Server and I'm using 2005 Express with SSMSE, and having trouble adding a record to a table "manually" by typing in the data.
I find I can change most of the fields by viewing the table in SSMSE and just clicking on the field and editing it then clicking "execute SQL" but for some reason the changes don't "take" when a date field is involved.
Is there a special or proper way to enter a date that I'm not aware of? I'm not having much success figuring out this online help stuff from within SSMSE, I keep getting to help on the help system itself (oops).
TIA!
View 3 Replies
View Related
Nov 24, 2007
In order to fix a web application bug the developer told me to to edit a stored procedure on my hosted SQL 2005 server. The hosting company's support say I should be able to do this using SQL Server Management Studio Express. I installed SSMSE, but it seems to want to only want to connect to a local server. Can I use this utility for remote DB management, or is there something else I need instead?
Thanks for your help.
-Michael
View 6 Replies
View Related
Aug 19, 2006
Hello, friends,
here is my problem:
I installed sql server express on a naked Windows xp pro with SP2; of course, framework 2.0 installed, and MS-installer 3.1 installed as well. I also installed ssmse. Everything worked fine.
Then I installed all windows updates via Windows Update in internet.
Now suddenly, when starting ssmse, I get a Warning Textbox with Header "Microsoft SQL Server Management Studio Express", then the yellow triangle with the exklamation mark, but NO TEXT AT ALL, and the OK-button. So unfortunately, I do not know what to do. Only thing I found out was, that in all updates, the culprit surely is framework 1.1 update. Before installing this, everything worked fine, afterwards, well, see above.
When I click the ok-button, everything works fine, I can log in into sql server express and do what I have to do.
So my only solution at the moment is just to ignore the warning - not the best way.
Couldn't find a better solution until now.
Could anybody help?
Kind regards from
Axolotl, Mellendorf, Germany
View 4 Replies
View Related
Apr 5, 2008
How can I know my sql server 2005 express service pack? The same goes for SSMSE. I can't find these information in the about box.
What about intelli sense for queries in SSMSE? Is it there yet or should I wait for sql server 2008 for dev. (http://channel9.msdn.com/Showpost.aspx?postid=387069)? I haven't seen the video but does anyone know any details? When it will be available, is it part of the sql server 2008 CTP, will it be available in the Express edition?
Thanks in advance,
Shehab.
View 1 Replies
View Related
