First Time Connecting To MSSQL But Error

Apr 15, 2006

Hi.

i am in my early days on intergrating MY Sql with PHP.
My windows 2000 server has bought PHP and MYsql installed.

When i attempt to connect to the mysql server using the forllowing PHP code
the below error message appears.

"Fatal error: Call to undefined function mysql_connect() in E:Web_Serverphpcon_mysql.php on line 2"

my php code is as follows.

[php]
<?php
$link = mysql_connect('MYSERVER', 'admin', '123456');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
[/php]


What could be the problem?

View 6 Replies


ADVERTISEMENT

Error When Connecting For The First Time

Sep 7, 2007

Hi, I get the below error (after clicking login in my home page, so home page works well) when I open my website for the first time after I restart my server or my client machine.
" Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."
 From the next time onwards it is connecting without any problems.
can anyone figure out what could be the problem here?

View 5 Replies View Related

Connecting To MSSQL In VBA?

Jan 9, 2007

This is kind of the wrong place to ask VBA questions, but I've been poking around for a day and haven't got the answer, so I am hoping I can get some help here.
 I am wondering if I can connect to MSSQL in MS Word Macro. If so, can I have some sample code please?
 Thanks

View 3 Replies View Related

Connecting To MSSQL-- All About It??

May 15, 2008

I'm just starting to learn ASP.NET (3.5) and I've gotten most of it down, but my failure to use a database is realy crippling my learning ability.
How do I connect to MSSQL?  I have Godaddy so they provide me with the username, password, url, etc.  If I could get a few examples for the following it would really help ALOT!


Connect to database

View 3 Replies View Related

Connecting To MSSQl In ASP.NET

May 23, 2007

This is the first asp.net application that I am trying to make.

After hours struggling wiht Plesk 8.1 I managed to create a MS SQL database and add a table to it.

How can I make a connection to this database now through ASP.NET?

Just mention it that I am using Visual Studio.net and I am working on a remote server.

View 1 Replies View Related

Connecting DB On A Pendrive In MSSQL 7.0

Sep 12, 2004

I am developing an application in VB. I want to know whether we can keep the database file (.mdf) on the pendrive in MS SQL 7.0. If this can be done HOW CAN THIS BE DONE Please guide me. It should be that when i connect my pendrive to the machine / server then i should be able to acess the database. This is a chellenging job which i have taken. Please guide me if this is possible.
Hoping for you HELP
THank YOu
Vikram Jain

View 2 Replies View Related

Connecting To A Web Based MSSQL DB

Jun 15, 2006

Hi all,

I'm running a MSSQL DB on our web server and currently I need to use Teratrax Database Manager to connect and manage it. Unfortunately this doesn't seem to have any features to export the data from the database.

I read somewhere about an online MSSQL tool which can manage online databases? Does this exist?

What tool would I use to connect to my database to export data from it? I have an evaluation copy of MS SQL Server 2005 but my knowledge with it is limited and I'm having trouble getting it connected to a remote DB (local DBs are fine).

Any help would be appreciated!

Thanks!

View 1 Replies View Related

Need Help Connecting Java To Mssql, I'm Even Lost At Install

Jan 17, 2007

Hello,

Hope anyone in here can help.
I have tried to install the SQL Server 5 Express, but can't seem to get it to work properly.
I got a terrible name set as default for my database, as well as a terrible name for my username.
I can't find a place to change this to something more manageable.

It is further set to windows auth, but trying to set it to both, and trying a username (and password) always gives me a log in error.

I've tried searching all over the net and in here for a simple tutorial, but can't seem to find one that helps me more than it confuses me.

*****
The second part of the problem is that I have a java program which I want to connect to the database and use the tables in it, but I am at loss to how I can find what username (and password) I am supposed to have, what "url" it needs etc.
I have the jdbc driver so that part should work, I can successfully log to other mssql databases (at work/school), but not my own.

Hope you can help, and thanks in advance.

View 3 Replies View Related

Connecting To MSSQL Server 2000 Using JDBC

Jun 18, 2007

Hello,

I am developing an application which needs JDBC connection to a Named Instance of SQL Server 2000 (other than default instance). I am facing problem in this regard as my code gives an exception "Time Out" or "Connection Failed". However it works fine with the default named instance...The main driver class is "com.microsoft.sqlserver.jdbc.SQLServerDriver"

and Connection URL is

"jdbc: sqlserver://localhost;instanceName=Testing:1432;databaseName=testDB;"



It gives the exception that Unable to connect to named instance....



Please if any one have any knowledge in this regard....do let me know....I have read an article on MSDN according to which on MS SQL Server 2000 the named Instance other than default can be accessed only through named pipes.

http://msdn2.microsoft.com/en-us/library/aa224779(sql.80).aspx



if some body can tell me Connection string for JDBC driver which utilizes named pipes...the it will be very help full for me.........any help from MSDN Experts is really appreciated...

Thanks

View 4 Replies View Related

Remote Connecting To MSSQL Through A VSTO Addin

Jan 28, 2008



Hi there everybody

I am a novice in using MSSQL and Windows 2003 solutions so I am having some problems.

I have made an excel addon in VSTO that connects to a MSSQL2005 server running on Windows 2003 on our internal domain, and it works great. Connection when I specify the domain adress is flawless. The thought is though that the addin is supposed to been used also outside our domain, so I have opened up our router and redirects all traffic to and from port 1433 to our MSSQL-server. This part should be ok.


I can then not connect to this server with our external ip specified. The error message Visual Studio produces is "An error has occured 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 connecteion failed because connected host has failed to respond.)"


I have read around and tried to fix this myself. I've specified to accept "Locale and remote connections" in the Surface Area Configuration Tool that shipped with MSSQL on both TCP/IP and named pipes. In the SQL Server Configuration Manager is the protocols Shared Memory and TCP/IP enabled. I have enabled all the IP-adresses under TCP/IP and specified 1433 as the port to use for all of them.


As for possible other problems I can see:
I have read a couple of places that people have tried to connect with the MSSQL server through telnet when specifying the port 1433 (telnet mydomain.net 1433). I have tried this but telnet is not getting a connection. Dont I have to open/forward more ports on the router to get telnet through?

I cant ping our external ip. Isnt this also a problem that is related to that I have not opened/forwarded ports on the router to our MSSQL server?


Do anyone of you have any tips or steps to take to narrow the problem down? This is not the forum for VSTO but thats not really where the problem is either, I think. It is probably somewhere in the configuration of MSSQL or Windows 2003. The server machine is set up as domain controller and DNS server for our local net.


I will appreciate all input, I am stuck at the moment...

Stein Agnar Sannes
Programmer (c, php, perl, java)

View 1 Replies View Related

Problem With Connecting With Online Mssql 2000 Database

Sep 30, 2007

dear all  i tried to connect to online mssql2000 database from enterprise manager,but i can't as i have a proxy server.how can i overcome this proxy server during connection ?

View 3 Replies View Related

How Do I Add Time With Integer Value In MSSQL ??

Nov 8, 2006

Hi, Expert
 
How Do I Add Time with integer value in MSSQL ??
For Example: 07:00:50 + 20 = 07:01:10
Note: 20 is in second
 Thanks in advance

View 2 Replies View Related

How To Select The Time From DateTime Format (MSSQL) ???

Oct 31, 2006

Hi expert.. I am doing a project that have function to capture the Day and Night time talking duration of caller.... I make use of MSSQL to store the date time file..Let say I have this date: "2006-10-02 00:02:09".. How di I select "00:02:09" only???? Thanks in advancesuigion

View 2 Replies View Related

Connecting To Default Instance For The First Time

Mar 16, 2008

I just installed Sql Server 2005, and opened the Sql Server management studio, and the connect to server dialog box popped up, i selected database engine, but what do I put in the server name box? I tried my computer name, and got an error, i tried localhost and got an error, i tried my computer name/localhost and got an error. I installed it as the default instance with windows authentication, and I verified that the sql server service is running, but I always get a login error. Can anyone help me get started?

View 5 Replies View Related

Connecting To Remote SQL Server - Time Out Expired?

Mar 23, 2006

Hello

Im connecting to a remote SQL Server in Enterprise Manager Via VPN,

we checked the connection and everything but still o cant connect

to the remote server, Error message says "Time Out Expired",

we checked the firewall config, ADSL connection and it's all Ok


what seems to be the problem here??

View 1 Replies View Related

Having A Hard Time Connecting To Sample SQL Database From ASP.Net Page

Jun 30, 2005

I am working through the book ASP.Net Unleashed Second Addition.  I am trying to open a simple database connection.  (using the sample "pubs" db from SQL Server)I have copied the author's code exactly, but it just won't work.  I keep getting this error:What am I doing wrong?????Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30182: Type expected.Source Error:





Line 5:
Line 6: Sub Page_Load
Line 7: Dim conPubs As SqlConnection
Line 8: conPubs = New SqlConnection( "server=localhost;uid=webuser;pwd=secret;database=pubs" )
Line 9: conPubs.Open()

View 5 Replies View Related

Error Handling In MSSQL - If Error During Call Remote Stored Prcedure I Need SQL Code To Continue...

Jul 20, 2005

Hi All,I want to catch the next MSSQL error in my SQL code with following continuecalculationsServer: Msg 17, Level 16, State 1, Line 1SQL Server does not exist or access denied.If REMOTE_SERVER_1 is inaccessible (as in (a) below) the executing of SQLwill not continue with (b) - I need the code in (b) to run despite whetherthe previous exec was successful or not - Any ideas?begin transaction(a) exec REMOTE_SERVER_1...bankinsert '1' , '1' , 1 , 0 , 0(b) print @@errorcommit transactionwhere REMOTE_SERVER_1 is link to server created byEXEC sp_addlinkedserver @server = 'REMOTE_SERVER_1', @srvproduct = '',@provider = 'SQLOLEDB', @datasrc = 'MYCOMP1', @catalog = 'mirror2'EXEC sp_addlinkedsrvlogin @rmtsrvname = 'REMOTE_SERVER_1', .....Exec sp_serveroption 'REMOTE_SERVER_1', 'data access', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'rpc out', 'true'Exec sp_serveroption 'REMOTE_SERVER_1', 'collation compatible', 'true'Any help will be greatly appreciated

View 1 Replies View Related

Error Connecting To SSIS - Error Loading Type Library/DLL

May 20, 2008

Hello,

I recently joined a company that is having an issue connecting to SQL Server Integration Services on one of their production servers. When trying to connect via management studio, both locally and remotely, they receive the error below. The server is a 64 bit server and is using third party replication (Veritas).

It sort of sounds like the issue described in this knowledge base article: http://support.microsoft.com/kb/919224. However, we do not have a problem creating maintenance plans. I'd just give it a shot but its a production server and getting approval to do anything that modifies the registry with the registry replication setup is a pain, so I'd like to determine if there could be another cause first.

TITLE: Connect to Server
------------------------------

Cannot connect to ***************.

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

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

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

------------------------------

Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) (Microsoft.SqlServer.DTSRuntimeWrap)

------------------------------

Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) (Microsoft.SqlServer.DTSRuntimeWrap)

------------------------------
BUTTONS:

OK
------------------------------

View 1 Replies View Related

[Performance Discussion] To Schedule A Time For Mssql Command, Which Way Would Be Faster And Get A Better Performance?

Sep 12, 2004

1. Use mssql server agent service to take the schedule
2. Use a .NET windows service with timers to call SqlClientConnection

above, which way would be faster and get a better performance?

View 2 Replies View Related

MSSQL Error

Jun 10, 2008

 
 
Hi all,
 
  i created a new login in MSSQLServer 2005 by the following options
  security -> Login -> NewLogin
  and i created the login name as test and password as test.
  when i try to connect the sqlserver using this username and password i'm getting the following error.
 "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)"
 please help me it is very urgent,
 

View 3 Replies View Related

MSSql Error 26

Jan 25, 2006

Hello,
I've create a test website with logincontrols, but if i have ulpoaded my website to a webserver and i want to login then a retrieve this error message everytime:

Server Error in '/' Application.


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)
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: 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)Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:



[SqlException (0x80131904): 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)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

please help me.
thanks, Joost

View 3 Replies View Related

MSSQL Error Help?

May 28, 2004

Anyone know why I might be getting this problem/error when I try to install MSSQL from the Microsoft website? Here's a picture of the error that I'm getting. And I have a 40+ gig hard drive and 36+ gigs of it are free. So, I don't know why I'm getting this problem. Can anyone help? I would greatly appreciate it, thanks!

View 5 Replies View Related

Urgent: Mssql Error Need Help

Jun 3, 2007

I've been working on a project that exchanges data with 2 different mssql dbs. Today I compiled my website and test it locally on remote databases. Everything seemed ok. Then I uploaded all files to the server and after an hour something strange has happened, I do not know why. I could still reach the website locally using remote connstrings but when I try to visit One of the databases could not be connected, ASP.NET said.

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)

Interesting thing is that website can authorize the request (I mean I can login) after that it throws this error.


Thanks

View 3 Replies View Related

Error While Doing DTS From INFORMIX To MSSQL

Apr 13, 2004

Dear All,

I'm using the DTS to transfer data from Informix 7.30 UC9 to MS SQL 2000 Enterprise. The tables I'm transferring contains data for BaaN ERP.

While transferring certain tables, I am successful. On some, I get an error that says "Data overflow". It was caused by "DBTYPE_DBTIMESTAMP".

Any idea why this happens?

Thanks!

View 2 Replies View Related

Error In Executing Asp&#043;mssql

Feb 9, 2007

Hello,

I hope this forum is suitable for posting my question.

I have a site in asp and vb with an access database. It's work just fine. I want to convert my database from access to mssql express. So I convert it with Microsoft SQL Server Migration Assistant for Access. I also install mssql server on my computer, so I can test my site at home.
But now, I have trouble, I've received many errors like:

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#'.
(this appear when I try to insert date and time in database, witch in access database I have no problem)

ODBC driver does not support the requested properties
(this appears when I make a selection in database, where I use inner join).

And many more ...

Do I have to rewrite the code to all my files? It's so different working with MSSQL comparing with Access database?

From what I read, I understand that after converting the database from Access to MSSQL, I must change only the connection string and the site have no problem. But it seems it's not so easy. I'm pretty disappointed.

Can you give me an advice? Or some links where I can read something that can help me.

Thanks.

View 4 Replies View Related

Error While Connecting

Sep 18, 2006

Hey all,I am new to ASP.NET. While executing a simple  code , i got the error: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Whats wrong? RegardsYasir

View 1 Replies View Related

Connecting To SQL Error 40

Mar 9, 2007

I'm trying to connect to an SQL server, but I'm unable. It suggests this is because SQL server does not allow remote connections, and points me to the named pipes provider, error 40 Could not open a connection to SQL server.
I am running SQL express service pack 2 under Vista. I am a member of SQL administrators (set during installation).
 Under the SQL Server Configuration manager, SQL server and Browser are running, the protocols for sqlexpress and the native client have enabled shared memory, named pipes, and tcp/ip.
I tried removing and creating a new database. Now it sits under the database Engine section of Management Studio Express, with a white circle on the database icon. When I try to connect to this database, using either windows authentication or sql server authentication, it fails.
 What else is there to try? If there was a troubleshooting guide, that would be helpful.

View 1 Replies View Related

Error Connecting To DB

Nov 10, 2007

I downloaded an ASP.NET web application from the web to learn the .NET framework. I was successful in running the website on my laptop using ASP.NET Development Server that comes with Visual Studio 2005. My laptop is running Windows XP Professional and SQL Server 2005. I am now trying to do the same on my desktop computer running Windows Vista; however, for some reason i am getting an error when the website tries to connect to the DB. Here are the steps i have followed so far:1. I tried to configure the website DB connection the same way i configured it on my laptop. Basically I use the following connectionStrings:   <connectionStrings>      <remove name="LocalSqlServer"/>     <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=TheBeerHouse;Integrated Security=True" providerName="System.Data.SqlClient"/>   </connectionStrings>2. That same connection string worked fine on my laptop. But I got the following error on my desktop: 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 wondering if the error is related to Vista. When i try to connect to that DB using SQL Management Studio via Windows Authetication and do not run it as Administrator then I cannot connect to the DB. In other words, only when i run SQL Management Studio as administrator i am able to use Windows authentication to connect to that DB.3. Next, I tried creating a SQL login. I made sure I can use that login to access the DB directly using SQL Management Studio. In addition, I changed the database to allow "Local and remote connections" "Using both TCP/IP and named pipes".4. Changed the connectionStrings in web.config to:   <connectionStrings>      <remove name="LocalSqlServer"/>     <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=TheBeerHouse;Integrated Security=False;uid=*****pwd=****" providerName="System.Data.SqlClient"/>   </connectionStrings> Obviously, the actual connectionString  has the actual user name i created and the correct password instead of (*) asterisks.5. And once again, I got same error as above Any help will be appreciated! 

View 8 Replies View Related

Error In Connecting A Db

Mar 10, 2008

Greetings, eveybody.

While attaching a sql db to a sqlDataSource, an error is poping up, stating that "the db is currently accessed by another process, the connection will be closed".
Plz put some light on this.
Thanking you,
Sankar.

View 1 Replies View Related

Error Connecting To DB

Feb 1, 2004

Hi everyone,

I am learning how to use .NET and MSDE. I am working out of the book "ASP.NET Unleashed" on the Job Site (Chap 30)

I have used osql to run the .sql script, but now I am having problems connecting to the DB; I get "SQL Server does not exist or access denied"

The web.config file is:

<configuration>
<appSettings>
<add key="constring"
value="Server=localhost;UID=AspNETJobsUser;PWD=secret;Database=AspNetJobs" />
</appSettings>
<system.web>
<authentication mode="Forms" >
<forms name=".ASPNETJOBS"
loginUrl="/aspnetjobs/site/password/login.aspx" />
</authentication>
</system.web>
</configuration>

My computer is running in Windows Authentication Mode.

I have tried replacing the UID and PWD to my sa account settings, but I still can not connect.
The books says I need to manually add a login that has access to the AspNETJobsDatabase, but I assume that would be the sa login or do I need to create another all together? If so, can anyone suggest an article to lead me in that direction.

Any suggestions would be helpful and greatly appreciated.

Thanks

View 5 Replies View Related

Error Connecting To Sql Db

Dec 10, 2004

I have an asp.net project on my laptop 'supposed to be' connecting to a SQL DB on the same machine. But I keep getting this error:

System.Data.SqlClient.SqlException: Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'xyz'.

It's driving me nuts. Any help would be appreciated.

txs
sonners

View 3 Replies View Related

Error Connecting To DB

Jan 22, 2007

Hi,

I have a major problem here. Hope you guys can help.

I have a VS2005 project that uses a DB I developed on and MSDE database using TOAD for SQL. A while ago I upgraded to SQL Server Express and all was well.

Next I was looking to create a deployment package for both the application and BD so after a bit of reading I created a connection to the DB in my VS2005 project with the intention of making it a dependency so both app and DB could be installed in one go (maybe not the best idea L). Previously I had just been using a connection string and opening/closing the connection as and when it was needed (this app only runs for 5 minutes each night).

This however has now stopped the ability to connect to the database with any of my DB development tools (Toad and the SQL management app that comes with express).

When I try to connect I get the following error

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

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

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

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQLDataCDEvolution.mdf'. (Microsoft SQL Server, Error: 5123)

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

------------------------------
BUTTONS:

OK
------------------------------


I had a look at the connection string that VS2005 is using and it looks nothing like the standard connection string I was using previously. It seems that the action of creating the connection with VS has changed/corrupted something on the DB.

To ad to my woes I also have to either change the connection string (this built using an xml file containing the all the elements of the string and parsed in allowing be to edit the string depending on the environment) to match the one VS is using or change my code to use the new connection.

I would prefer to revert back to the way it was working previously and figure out a different method of deploying the software.

Any thoughts?

Cheers,
Kevin.

View 1 Replies View Related

Error While Connecting

Oct 5, 2007

Dear All,
I've created a new database for our new project, taken the scripts from VSS, as there is no error in the scripts, i've run the scripts and everything is fine with sql server 2000.
but while i'm trying to connect to the database from 2005, it is getting error....as the database 'db086' is not accessible.(microsoft.sqlserver.express.objectexplorer).

what will be the cause???
i'm working fine with the database with sql server 2000.

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related







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