Strange Problem ! Connect To Database !

Oct 29, 2005

Hey u guys.I have a strange problem and non of myfriends can solve it.The story is like this:I want to connect to my database at my hosting from SQL Query Analyser.With the same SQL server, username and password.But there is only me who can not connect by that way.This is the error of that problem, i made a screenshot for it.Please click here: http://www.xhnguyen.info/sql.JPGAnyone had this problem before ?Could anyone please help me solve it?Thank you very much.Joesy

View 1 Replies


ADVERTISEMENT

Strange Connect Problem

Sep 24, 2007

Hello,I try to get an asp site to work on my local machine. Using ASP Studio2005 and mssql server 2005 eval on win xp, and ms management studio.I'm new to mssql and asp and just want to get the site to run (notedit). have a simple connect script likeset conn = server.CreateObject("adodb.connection")conString ="PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL;DATABASE=nano;UserID=sa;Password=yyy"conn.open conStringwhat happens is that IE hangs on load. the settings in the string areall ok I think: if I change id or pw (that is to any non-existinguser), immediately comes error like "problem logging in user sa". onlywith the correct values, IE hangs. this makes me believe that thesettings are right, but that the hanging comes from anything else. anyideas anyone? port problem? which is right? how to check? what else?how to detect? where are error logs? how to get detailed info?i would also be lucky with no-authentication - butconString ="PROVIDER=SQLOLEDB;DATASOURCE=DANIEL;DATABASE=nano;Integrated Security=SSPI"without uid and pw also results in hanging. so I now think the connstrings is ok. what is wrong?? [since I am new, and just took theproject from a cd, please also ask me "stupid"questions/suggestions!!] thank you VERY much!!!!daniel

View 1 Replies View Related

Strange Remote Connect Issue

Apr 22, 2007

I recently switched servers and I'm running into the a really strange remote connection issue.

The server is brand new Windows 2003 fully updated , .NET 2.0 and 3.0 installed, trying remote connection using VS2005 and the full edition of Management Studio. Managment Studio Express is installed on box.

Firewall is not blocking UDP port 1434 or TCP port 1433 or any other normal port, verified with Netstats

First I tried to install SQLExpress Advanced Services as a default instance. The install worked fine with no issues. I enabled remote connections in the surface area config tool and then restarted the service. When I attempted to connect using xx.xx.xx.xxx or xx.xx.xx.xxy on the local machine using TCP or NP with SQL authentication it worked fine. Then I tried to connect from my remote machine and I recieved one of these errors:

Using TCP

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.)


Using NP

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)


Next I contacted my hosting company they recommended that I reinstall which I did this time as a Named Instance did the remote configuration, started the sql browser and got the connections working on the local machine using

.SQLEXPRESS

or xx.xx.xx.xxxSQLEXPRESS or xx.xx.xx.xxySQLEXPRESS

Tried again from my remote machine get the

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.Error 26 (can't find a server at this address error)



Any suggestions??

View 4 Replies View Related

MSDE Remote Connect Strange Problem

Jan 25, 2006

I'm trying to connect to the SharePoint MSDE database from Windows XP


SP2 machine over Ethernet LAN. I was getting server not found or access


denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting





OK


Connection failed:


SQLState: '01000'


SQL Server Error: 10061


[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen


(Connect()).


Connection failed:


SQLState: '08001'


SQL Server Error: 17


[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not


exist or access denied.





I just did an netstat -an and I don't see the server listening on 1433.


What am I not doing?





The svrnetcn tool has no effect. I make a change and check the logs,


but nothing happens. What would be causing this?

View 4 Replies View Related

Failed To Connect To Sql Server Problem - A Strange One!

Jan 30, 2007

Full Error message is:

Failed to connect to server DDI-DP9IM5A5F5W. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

When I consult the error log I see:

Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2007-01-30 04:53:14.93 Logon Error: 17809, Severity: 20, State: 3.

_____________________________________________________________

The log error message doesn't make any sense because there aren't 4 user connections.

After I received the error message, mgmt studio still lets me access the database make changes, but I cannot connect via my application. Any ideas? Thanks!

View 8 Replies View Related

Strange Database Problem

Jan 7, 2008

I built an ASP.NET application that works with SQL Server Express 2005.  I am using Typed Datasets to interact with the database, and everything works well on my staging server (Windows 2003). 
However, when I deployed the application to the clients server, no updates actually work!  I try adding new items through the interface to no avail.  I try updating data through the interface and nothing works.  The strange thing is, I get no errors! 
Has anyone ever encountered this before?
Karls

View 1 Replies View Related

Database Acting Strange

Jan 20, 2004

MY DATABASE FOR SHOPPING CART IS ACTING STRANGE IT HAS AUTOMATICALLY DESTOYED ALL PRIMARY KEYS. AND HAS CREATED 4 DUPLICATE RECORDS FOR EACH RECORD SO AT THIS STAGE I HAVE AROUNG 15000 RECORDS IN EACH TABLE IT MEANS 15 TIMES 4 60000 RECORDS. CAN ANYONE UPDATEME WHY THIS HAS HAPPENED AND WHAT CAN BE DONE TO DELETE EXISTING DUPLICATES. I NEED FAST REPLY IN THIS MATTER AS THIS IS URGENT. IF POSSIBLE KINDLY WRITE QUERIES TRIGGERS FOR FUTURE PROBLEMS AS WELL AS THESE DAYS I AM SICK SO MY BRAIN AINT WORKING IN THIS MATTER. URGENT URGENT URGENT THANKS ALOT I HAVE PREVIOUSLY POSTED AND HAVE GOT A GOOD RESPONSE. AND HOPE A GOOD ONE AGAIN. ONE MORE THING IS THAT I HAVE A BACKUP HERE AT MY OFFICE SYSTEM IT ALSO HAS DONE THE SAMETHING. I MADE A NEW DATABASE AND TRYED TO IMPORT DATA WITH DISTINCT KEYWORD BUUT IT IS NOT COPYING IT AS WELL. URGENT RESPONSE REQUIRED IF ANYONE CAN DO.

View 9 Replies View Related

Strange Database Problem

Aug 23, 2005

Hello,At work we have various servers, therefore we have various DTS Interfaceswhich transfer data between them.However when trying to save a new View to one server which gets its datafrom another server nothing happens, I get an hourglass and nothing else.Then I have to exit out of SQL Enterprise Manager and then no-one can accessthe database on that server, so we had to restore from backup!The query to create the view resides on server AThe query is getting its data from server BBut the query does need to reside on server A for other reasons.What does this sound like to you?I am suspecting connection problems between server A and B but the queryruns, its only when I save the view that this happens.I am puzzled.Thanks,Jayne

View 1 Replies View Related

Strange Database Deadlock

Jul 20, 2005

Hi,I had a deadlock situation on SQLServer 2000. When I look at theLocks / process ID screen on Enterprise Manager, for one of thesession, I see the object being one table and the index is on anothertotally unrelated table's primary key. This is really odd since thereare no foreign keys tying these two tables together. They don't evenreference the same parent tables. These two tables are quitedis-joint. Does anyone know why I will get this kind of lock?Thanks,Maggie :)

View 2 Replies View Related

Can't Copy Database, Strange Error

Sep 25, 2006

I'm trying to copy a database from my web host to local Sql Server 2005 instance using the Copy Database wizard.  I get this error:An exception occurred while executing a Transact-SQL statement or batch. Server user 'celestine' is not a valid user id database 'db2'.However, 'db2' isn't the database I was trying to copy!  I am trying to copy db1, but this error is complaining about db2, which is in fact somebody else's database that I don't have a login for.  Why am I getting an error about db2 when I'm not trying to do anything with db2???I can however export the tables from db1 just fine using Export.  But then I have to go back and generate script to re-create the stored procs, views, etc., so it is rather tedious to do it that way.  

View 4 Replies View Related

Strange Error When Connecting To Database.

May 11, 2008

 Hello,
I'm tyring a simple piece of code to conenct to my database: SqlConnection con = new SqlConnection("Data Source=localhost; Initial Catalog=OrderingSystem; Integrated Security=SSPI");
try
{
// Try to open the connection.
con.Open();
label1.Text = "&lt;b>Server Version:</b> " + con.ServerVersion;
label1.Text += "&lt;br /><b>Connection Is:</b> " + con.State.ToString();
}
catch (Exception err)
{
// Handle an error by displaying the information.
label1.Text = "Error reading the database. " + err.Message;
}
finally
{
// Either way, make sure the connection is properly closed.
// Even if the connection wasn't opened successfully,
// calling Close() won't cause an error.
con.Close();
label1.Text += "&lt;br /><b>Now Connection Is:</b> " +
con.State.ToString();
}
When I try this, I get an error:"Error reading the database. Cannot open database "OrderingSystem" requested by the login. The login failed. Login failed for user 'NT AUTHORITYNETWORK SERVICE'."
The strange thing is, this code works perfectly If I use it in a Windows Forms application.
Is it a problem with SQL server, IIS or my code?I'm using SQL Server 2005 (SP2) 32bit developer edition + IIS 6.0 + Visual Studio 2008 Pro all runnign on my Windows XP x64 PC.
Thankyou

View 2 Replies View Related

Strange Error Restoring Database

Jul 9, 2001

Hi all.

I was just restoring one database and creating another concurrently on the same server. The restore took longer than the create due to the respective sizes.
After the create had finished (done in Query Analyzer) I went back to the restore to see how it was getting on (running in Enterprise Manager).
There was an error (which I didn't record exactly - DOH!) along the lines of "could not obtain a lock on the model database, restore terminating abnormally."
I guess the create had model locked while it was creating the default objects, but what was a *restore* doing needing the model database anyway?

Any comments would be interesting.

Andy Tynan

View 1 Replies View Related

Strange Error For Database Integrity Check Maintenance Job

May 16, 2008

Hi gurus:

I met a very strange problem recently. I set up a database integrity check maintenance plan. But this job failed every time. I looked into the logs, the error message was that Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped. I used the sp_helpdb to check the version of the databases included in my maintenance plan. The sp result shows that all the databases are above version 80....

Even more strange, i can successfully run the dbcc check query on each database.

Any comment and suggestion will be very appreciated.

View 1 Replies View Related

Strange Error On Linked Server - Cannot Open Default Database

Apr 16, 2007

Hi,We have 2 servers. Server1 is a 2000 box, with SP3 (yes I know it isnot up to date). Server2 is a 2005 box, SP2.I set up Server1 (2000) to have a linked server to Server2 (2005). Thereason I did this is because we are using a stored procedure onServer2 to send mail, as we have found that using mail on 2000 doesn'talways work as advertised.When I set up the linked server on the 2000 box, for security I justset it up to use a SQL Server user on the 2005 box. The SQL Serveruser on the 2005 box has permissions to run the stored procedure forsending mail.Here's the weird thing though. When calling the stored procedure onthe 2005 box from the 2000 box, sometimes we get an error that "Thedefault database cannot be opened", and the query does not run on the2005 box. However, it only happens *sometimes*. Other times, the queryruns fine.Since the problem seeemed to be with the default database, I changedthe SQL Server user on 2005 default database to the SAME database thatcontains the stored procedure.However, I just don't understand why it's even TRYING to open thedefault database, since when we called the linked server we are doingso as, and it's referencing the default database in the name:EXEC Server2.DefaultDatabase.dbo.StoredProcedureNameHowever, after changing the user's default database to"DefaultDatabase" as shown above, the query runs fine.Why are we having this problem? That is, if I change the defaultdatabase to something other than "DefaultDatabase", then the querydoesn't run, even though the database name is referenced in the abovequery??Obviously, this is not desireable, because that means we can only runqueries that are in "DefaultDatabase", which may not always be thecase.Thanks much

View 2 Replies View Related

Delay Between CREATE DATABASE And Ability To Connect To That Database

Oct 9, 2006

I have an application that creates a new database during installation,and I've noticed some strange behavior. Once I've created thedatabase, I am able to immediately create tables and populate lookupdata, provided I remain connected to the server. If, however, Idisconnect and attempt to reconnect immediately, I'll get an errorsaying that my login is invalid for the new database.I can get around this by having my code simply wait 5 seconds beforeattempting to reconnect, but I'm curious to see if anybody here cangive an explaination for why this is happening. Here is a bit ofpseudo code to explain what I'm seeing:open new connectioncreate databasecreate tablespopulate tablesclose connection// open new connection /* can't do this yet, as it would break */for (int a=0; a<5; a++){Thread.Sleep(2000)try{open new connectionbreak;}catch{Debug("still waiting...");}}Running my version of this code, I'll see that "still waiting..."message go past 2-3 times before SQL Server wakes up and realizes thatI'm allowed to connect to it. Anybody know why?Thanks,Jason KesterExpat Software Consulting Serviceshttp://www.expatsoftware.com/---Get your own Travel Blog, with itinerary maps and photos!http://www.blogabond.com/

View 1 Replies View Related

Strange, Very Strange (BIDS)

Jul 19, 2006

Hi everyone,

I€™m suffering a queer behaviour when I use BIDS. Concretely, when I open a dtsx from my project (it has 10 packages) many times Sequence Container and Data Flow tasks are invisible. I mean, its lines are not visible at all whereas its titles are. I mean, what you see is just a white box€¦

Then, I€™m gonna Data Flow layer and I have to do double-clik over the tasks and are visible but on Control Flow I don€™t see how to solve.

Curiously in our development and production server such behaviour doesn€™t happen (we are accessing by mean Terminal Server from our workstations)

How odd!. Everything is fine except this.

I want to remark you that such project has been copied from the server, this is, these packages are been built on the server

Thanks for your thougts or ideas,

View 5 Replies View Related

Can Connect To Database, But How Do I Insert Values Into SQL Database?

Jun 14, 2006

I was able to connect to the SQL Database Pension with table clients with table values: ID, State, Name.'Create(connection)Dim conn As New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)'open connectionconn.Open()However, I'm not sure how to insert a new row with an incremental ID number and a new State and Name.Sorry, I'm really new with VWD.

View 1 Replies View Related

Adventure Works Database, I Can't Connect To The Database

Jul 16, 2006

Database not found !

My web.config file has this bit of code:

<connectionStrings>

<add name="AppConnectionString1" connectionString="Data Source=&quot;.SQLEXPRESS&quot;;AttachDbFilename=&quot;C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_Data.mdf&quot;;Integrated Security=True"

providerName="System.Data.SqlClient" />

</connectionStrings>

But........................... the is no "AdventureWorks_Data.mdf" in that folder ?

And the database is installed in the right place !

help !

View 6 Replies View Related

Can Not Connect To Database

Aug 10, 2006

I am new to windows apps in .net 2.0. I am trying to create a windows service that will connect to a database and email info out to people that have had status changes.
Right now, I can not connect to the database. Here is the connection string:
Private cnn As New SqlClient.SqlConnection("Data Source=IPAddress;Initial Catalog=TheServer;Persist Security Info=True;User ID=userid;Password=password provider=SQLOLEDB.1;connect timeout=3600")
This is how I am trying to connect:
cnn.Open()
myCMD.CommandTimeout = 0
dr = myCMD.ExecuteReader
 
I keep getting an error message that I can not be logged on. I know that the credentials are correct because I use them for the web app. Something has to be wrong with my connection string, but what?
Thanks,
enak

View 2 Replies View Related

Cannot Connect To Sql Database

Sep 1, 2006

 I'm using Visual Web Developer and SQL 2005...It Guives me this 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I'm tired of guetin and search solution for this errorI've tried everything that i searched over the "net"...made all the configurations possible in sql server 2005 and nothing...Is this right? Or do i need to put some more code in this line or in server is it "localhost:****...: ...connection = New SqlConnection("Server=servernameWebSite1uid=sa;pwd=1234;database=cdcollection")connection.Open()...... Don't know why in sql server i have two object explorer connections when i start the sql server...one is  "servername"...two is "servernamesqlexpress" (but when trying to connect with "servernamesqlexpress" it won't let me, only with "servername")...i use the windows authentication......when i had the VB.NET 2003 and SQL Server 2000, it was much easy to do this... In ASP.NET config i still have the C:inetpubwwwroot path but the files don't go there...now they go to my documentsVisual studio 2005 by default of Visual Web Developer prog. Do i need to change the location? Please help...i'm really desperate...with this... 

View 2 Replies View Related

Can't Connect To Database

Nov 1, 2006

I am developing my first website for my boss.  I am trying to connect to an access database which I have created a DSN for on the server.  I am using the following code sample.... //Connection String 1string dsn_name = "access_WALLINVEN.dsn";string sDSNDir = Server.MapPath("_dsn");string connectstr = ("Data Source="+ (sDSNDir + ("\" + dsn_name)));//Connection String 2string connectstr = "Data Source=/jwallpaint/_dsn/access_WALLINVEN.dsn;Uid=jwallpaint;Pwd=J2512wall;";string commandString = "Select * from Inventory";//Pass strings to sqlDataAdapter constructorSqlDataAdapter dataAdapter = new SqlDataAdapter(commandString, connectstr);//Create a datasetDataSet dataSet = new DataSet();//fill the dataset objectdataAdapter.Fill(dataSet, "Inventory");//Get the table from the datasetDataTable dataTable = dataSet.Tables["Inventory"];//Bind to the gridviewGridView1.DataSource = dataTable;GridView1.DataBind();For Connection String 1 I get the error of...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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) For Connection String 2 I get the error of...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) I am not sure which connection string to use either....It is strange to me that I get this error talking about SQL Server when I am trying to reach my Access database......Any Help??  Thanks....

View 1 Replies View Related

VWD - Cannot Connect To Database.

Nov 17, 2006

Hi,
I'm on lesson 7 of the Bob Tabor video tutorial called 'Data binding to user interface controls'. Whenever I try to add an SQL database (add new item/sql database) I get the following error message:
TITLE: Connect to Server
------------------------------
 
Cannot connect to ALFIESQLEXPRESS.
 
------------------------------
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
I have VWD installed, sqlexpress installed, everything really.
Any help would be appreciated.
MD

View 1 Replies View Related

Cannot Connect To Database

Nov 30, 2006

I am attempting to connect to a database that has been uploaded to my server from my webpages on the server.  This is the connection string that is currently used:
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Restaurants.mdf;Integrated Security=True;User Instance=True"
When attempting to connect to the database I receive this error message:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I realize that I cannot make a remote connection using SQL Server 2005 Express Edition, but cannot find the proper connection string for it to connect to the uploaded database.
Accessing the database doesn't require a log on by the user as all the information is public.
The authentication mode in the web.config file is set to "Forms".
 If there is any other information required so that this problem can be solved, please ask for it.
Thank you in advance,
Me

View 1 Replies View Related

Just Cant Connect To Database.

Apr 17, 2007

when i run application from visual studio im getting this error. Server Error in '/' Application.
Cannot open database "Products" requested by the login. The login failed.
Login failed for user 'GAMERKALESH'. when run from web browser:  Server Error in '/' Application.Cannot open database "Products" requested by the login. The login failed.Login failed for user 'GAMERASPNET'. my comp name is: Gamerand acc name is : Kalesh using Microsoft Studio Server Management studio express  i have added these accs:in security of databas products: ASPNET and IUSR_GAMER in general security i have added accs: GAMERASPNET and GAMERIUSR_GAMER using windows authentication.  

View 1 Replies View Related

Can't Connect To Database

Sep 11, 2007

 I just did a ton of work in SQL Server Management Studio Express and now I want to access the database from a Web Developer 2005 Express Edition application.  Can't find any documentation on how to connect to the database from vwd.  Any assistance would be appreciated. Thanks, Tom 

View 3 Replies View Related

Can't Connect To Database

Sep 21, 2007

Ok I have several sites on a server that have connected to databases on a different server for a long.  Out of the blue today none of the sites on the server can connect to any databases on the other server.  However, sites on other servers can connect to databases on the same db server.This is the message 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)The database server runs SQL Server 2000 not 2005 I can connect to the database from desktop (with an asp.net application or sql server management studio), I can ping the database server fine from the production web server, but my applications can't connect for some reason.  There is nothing in the event log to suggest a problem, any ideas what could be causing this?  

View 3 Replies View Related

Not Able To Connect To Sql Database

Sep 30, 2007

Hello,
 I have posted awhile ago about this issue, but after taking the advice and trying to get help from GoDaddy, nothing has worked yet.  I am using the user login control, and then I changed the connection string in the web config file according to what Go Daddy's help file said, making sure to make proper server, id, and password names.  It still won't go through, can anyone help?
 
Thanks

View 3 Replies View Related

How To Connect With SQL Database?

Oct 25, 2007

I am new learner of ASP.NET and coding in C#.I am not able to connect the SQL database.I have written the code for connection of database but to write the connection string web.config file is neccessary which is not apearing in my application. Please help me .Here is code I have written.   
 
string sCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();SqlConnection oCon = new SqlConnection(sCon);
try
{
oCon.Open();string sQuery = "Select Offering1,Offering2,Offering3 from Offering";SqlCommand oCmd = new SqlCommand(sQuery, oCon);
oCmd.ExecuteNonQuery();
DataSet oDs = new DataSet();SqlDataAdapter oDa = new SqlDataAdapter(oCmd);
oDa.Fill(oDs);
DataList1.DataSource = oDs;
DataList1.DataBind();
} catch (Exception ex)
{
ex.ToString();
}

View 17 Replies View Related

Can Not Connect To Database

Jan 4, 2005

I recently uninstalled SQL Server due to connection issues I started having. I could start the DB and connect/edit tables in Ent Mgr etc, but all the sudden, none of my code could make DB connections.

So, after reinstalling now nothing works. I cannot even connect in Ent. Manager. I went to Administrative Tools->Services to make sure it was running, and SQLSERVER isn't even listed under services. What happened? Is there another step after installing SQL Server I missed to get the service up and going. Do I need to do something in ODBC connections?

I am on Windows XP with SP2.

Tim

View 12 Replies View Related

Could Not Connect To Database

Jan 16, 2005

Hello I am new to the ASP.NET project and using Microsoft ASP.Net Web Matrix. When I try to connect to an Access Database it is no problem, but do I try to set up an connection with a SQL or MSDE database there is a problem.

It can not connect with my SQL server and gives the error:
Could not create new database.

What can be the problem. My MSSQL Server is running perfect.

Greets
Ben
Holland

View 1 Replies View Related

Help Me About Connect To My Database

Aug 7, 2005

i design a web site by vs.net 2003 and i connect to sql database its name rayan but when build my webfrom a error show this is   system.data.sqlclient.sqlexception:login faild for user "rayanaspnet" please help me

View 1 Replies View Related

Cannot Connect To Database Using EM

Apr 25, 2006

Greetings,

A newbie needing some guidance. We have SQL running on our Windows 2003 server. When I connect via the Enterprise manager I have two instances of SQL running.

SRV01ACT7 (Windows NT)
SRV01WEBAPP (Windows NT)

When I click on the ACT instance I get the following error:
A connection could not be established to SRV01/ACT7

Reason: Login Failed for user xxxxadministrator.
Please verify SQL Server is running and check your SQL Server registration properties.

I only get the message when I try to connect to the SRV01ACT. The connection to SRV01WEBAPP works fine.

I checked with SQL server manager and both instances are running and no one has reported any problems connecting to either one of them.

The way it acts, its as if SQL server has lost the ability to authorize a connection via the windows account. As if it has lost its associatoin to the administrator account. So while the instance still runs and is functional, I just can't connect to it and manage it.

I have connected via remote desktop from a WinXP machine and the server console. Both end up with the same error.

Can Someone give me step by step instructions on how to correct this?

Any help please!!!

View 20 Replies View Related

Cannot Connect To Database From App

Sep 24, 2007

Update: I got it working. I had to create an odbc connection on my machine (guess I forgot to do that this time).



I copied a SQL 2005 database from another machine (detached it first. I can connect directly in SFT SQL Server Mgmt Studio, but I cannot connect from VFP using SQLCONNECT(). I've overlooked something. My login is the db_owner and everything else. Any ideas? SQL Server is running on the same machine that I have VFP9 on. It is setup for both SQL Server and Windows Authentication and I can connect to every other database I have attached.

TIA,

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved