Sqlexpress Sa Connection

Oct 20, 2006

Hi guys.



I have Windows XP pro with IIS + sqlexpress

My problem is, I am writing a code with classic asp, to connect to sqlexpres database and somehow something blocking me. My first try was unsuccessfull , it was keep getting timeout. then I did something and now I am getting this error message shown below;

Error Type:
Microsoft OLE DB Service Components (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/myfolder/opendb.asp, line 5


I am using SA user to connecto the server. When I checked the server with managment tool I found out sa doesn't have permission to use this new database of mine. So I tried to add that by going into

Security>logins>SA >properties > usermapping. Then I found and checked the new database . I get an error message shown below;

Create failed for user 'sa' (microsoft.sqlserver.express.smo)

additional information:

an exception occured while executing a transact-sql statement or batch.

(microsoft.sqlserver.express.connectioninfo)

Cannot use the special principal 'sa' (microsoft sql error, error 15405)



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

Also my second question is I downloaded web data administrator and I do not know how to login. what is the default username and password??



I thankyou very much for the help ahead.

Cemal

View 3 Replies


ADVERTISEMENT

SQLEXPRESS Connection String In Asp?

Aug 20, 2007

So i get this version of sqlexpress up and running and i copy all my databases over on to it. Redo my Logins for te server and then add the the DSN to ODBC admin console.
And still no good >:_( this is the error i get:

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "publicSite" requested by the login. The login failed.

So i know im doing somthing really stupid.

So heres what i got:

ASP connection srting looks like this:

<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="true"
// Catalog=""
// Schema=""
var MM_PublicSiteJS_STRING = "dsn=publicUSR;uid=publicUSR;pwd=**********"
%>

now it ther a special ODBC driver used for SQLExpress or can i use a standard SQL driver?

any help would be much apriciated.


View 3 Replies View Related

Close Connection Of SQLExpress!

Mar 12, 2007

Hi,

I write a .NET Windows Form that connect to SQLExpress datafile. After updating data, I want to zip the .mdf file and send email. However, I got an exeption that the .mdf file is used by other thread so I cant zip. Even I try to close all connection, I still cant zip.

Is there any way to detach/unlock .mdf file connecting by SQLExpress?

MA.



View 3 Replies View Related

How Many Connection Sqlexpress Supports

Mar 8, 2006

I see this question a lot, so I thought I would go ahead and post the answer here.

Q: How many connections does SQL Server Express support?

A: Unlike MSDE, SQL Server Express does not limit connections.  SQL Server Express supports:

1 gb RAM (note the machine can have more memory, but 1gb will be used by SQL Express)
1 processor (again, the machine can have more, but just 1 proc will be used by SQL Express)
4 gb database size (note, there can be multiple databases, but none of them individually can be more than 4 gb)

Hope this helps,

Thanks< MJ

View 1 Replies View Related

SQLEXPRESS Via LAN REFUSE CONNECTION!

Mar 24, 2006

0) I've build on my pc a file MDF...i've used it and it's all right.

Then  I've decided to use it in LAN on pc-server to share it with my team.

1) The sqlexpress is installad on pc with XP sp2 (as server)

2) Tcp Ip is enabled.

3) Firewall is not running

4) The folder where is located the Mdf file si public without restrictions

5) The autentication is performed via Windows.

6) The service sqlbrowser is enable and running at start.

http://www.base2.it/img/sql1.JPG

http://www.base2.it/img/sql2.JPG

What's the  problem?

View 3 Replies View Related

Lost Connection With Sqlexpress

Jun 15, 2006

I installed on a w2k/sp4 local machine SQLEXPRESS.

I copied the database also to the localmachine

With the sqlexpressmanager I attached the database. Everythinks looks fine.

I quit the manager, but then I start the manager again. Now the manager can't find the sqlserver.

Timeout Expired is the message.

Why is that? I installed SQLEDXPRESS on a lot of machines. No problems. But those machine the manager lost the connection after the first time.

 

thanks again.

klaas

http://www.planmatigonderhoud.nl

View 4 Replies View Related

ASP.NET 2.0-SQLEXPRESS 2005 Connection Problem

Feb 9, 2007

i got an error just like that.What must i do?
 
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)
 
 

View 5 Replies View Related

Perl Connection String For SQLexpress

Apr 29, 2008

#!perl

I am having difficulty converting my CGI(perl module) connection from mySQL to SQLexpress. Does anyone know what the connection string should look like?
Listed here is my current connection string. I'm trying to get this done this week. Please email me if you have an answer in addition to posting.

$dbh = DBI->connect("DBI:mysql:database=$var{database};host=$var{server}","$var{root_username}", "$var{root_password}",{'RaiseError' => 0, 'PrintError' => 0});

Much appreciated,

JOhn

View 2 Replies View Related

SQLExpress Connection Trouble In Web Site

Sep 12, 2007

Hi all,

I followed an excellent tutorial (from Microsoft) about creating and using a SQLExpress db table internal to your website and the site I created works just fine - locally. When I publish to my web host provider I get this error:

[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)]

My web host provider supports .NET 2.0 but doesn't support MS SQL Server. But that should matter - right? Because I'm putting the db instance right in the website?

I did a search and followed some of the advice:

I went into the SQL Server Surface Area Config Mgr and set SQLExpress for local and remote connections and rebooted/republished. I also have SQL Server 2005 installed as a separate entity (if that makes a difference).

I still get the above error. This is the connection string from the web.config:

<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Customers.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

And this is the call from the markup:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT * FROM [Customer]"></asp:SqlDataSource>

Does any know the fix for this?

Thanking you in advance

Pat

View 3 Replies View Related

Remote SqlExpress Connection And Firewall

Apr 12, 2008

I am running SqlExpress on a Vista machine as a server and accessing it from machines running XP. I could not connect with the Vista server until I turned off the firewall, despite creating exceptions for both the sqlexpress and sqlbrowser services in the firewall setup. Obviously, I don't want to run on a wireless network without a firewall for any length of time. What else to I need to enable in order to run with my firewall up? In SMSS, I could 'see' the Vista server on the network with the firewall up, but I could not 'see' the SERVERSQLEXPRESS service or connect to it .

thanks,

Steve

View 4 Replies View Related

MSSQLSERVER And SQLEXPRESS Connection Issues

Apr 14, 2008

I am using Visual Studio 2005. I am creating an SQL database with a web enabled front end. I am using Microsoft SQL Server Management Studio to create the database objects and an ASP.NET web page created in Visual Studio for the front end. My problem is centered around the two server instances which come with Visual Studio (MSSQLSERVER and SQLEXPRESS). The database objects are being created on MSSQLSERVER by Microsoft SQL Server Management Studio. However, in a Visual Studio ASP.NET web page, when I create a new conection string using the menu functionality, in the SQLDATASOURCE object or in the server explorer, only (My Computer Name)SQLEXPRESS shows up as an option. I have tried typing (My Computer Name)MSSQLSERVER in but the database list just comes up blank. I know that MSSQLSERVER exists because I have one active connection string to it created by a friend. They had to juggle a lot of things to make MSSQLSERVER appear and since I was just getting started then it went over my head. Whatever they did was temporary though and I havn't been able to repeat it to add new connection strings. To eliminate some of the obvious things in other posts:

*MSSQLSERVER is Started in the Services Screen
*In the configuration manager MSSQLSERVER has shared memory enabled
*On the advice of one post or proceedure I enabled TCP/IP and restarted the service (I think this is actually for remote connections everything I am doing is on one PC)


What I really want is to have things permanently set up so MSSQLSERVER always shows up as an option when creating a connection string in Visual Studio. If this means getting rid of SQLEXPRESS I won't shed too many tears.

As you have noticed everything in this is centered around Visual Studio's menu functionality. I am currently make thee code paradigm shifts.

Form -> ASP.NET
VB6 -> VB .method
ADO -> SQL

I have created some pages in ASP.NET and have started creating objects using source instead of designer.
I have automated some of the functionality on those pages using VB .method programing
While I have created some simple SQL select and bulk insert statements my SQL is still pretty weak and I haven't learned connection strings or driving changes back to the database using Transact-SQL

View 5 Replies View Related

Sqlexpress Connection On Hosted Server

Sep 7, 2006

I am using a virtual dedicated server to host sqlexpress at a remote site. I can't get the connection from MS SQL Server Management Studio Express to connect over the Internet. I only have the box IP address (xxx.xxx.xxx.xxx) and have tried various forms of xxx.xxx.xxx.xxxsqlexpress as the server name.

Can someone point me in the right direction please?

Thanks, John

View 3 Replies View Related

Problem In Connection To Sqlexpress Witn ASP.nET

Apr 6, 2006

hi all

When I use asp.net 2.1 to connect sql 2005 express locally I got error message to say

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: 25 - Connection string is not valid)


I use following connection string

ConnectToDb.ConnectionString = "Data Source=servername;InitialCatalog=PushToMail;Integrated Security=true";

for more information : when I open SQLEXPRESS this oblige me to inter

servername : servernamesqlexpress

authentification: windowsauthentification

and when i try this connection

ConnectToDb.ConnectionString = "Data Source=servernamesqlexpress;InitialCatalog=PushToMail;Integrated

Security=true";

l got this erreur "inorganised sequence space"

View 3 Replies View Related

Connection To SQLEXPRESS Was Working And Then... It Wasn't

Apr 23, 2008



I see a few have had this problem but their answers didn't help.

My connection string:


"Data Source=.SQLEXPRESS; Integrated Security=True;AttachDbFilename=|DataDirectory|TestApp.mdf;Initial Catalog=TestApp"

and the error a am getting is:

Cannot open database "TestApp" requested by the login. The login failed.
Login failed for user 'ComputerName\TheHaggis'.

Like i said it work a couple of times and then i get this error.

what am i do wrong

cheers

the Haggis

View 5 Replies View Related

Tools To See Open Connection, Transactions ... SQLExpress

Jun 15, 2005

Hello - where I can find the tools to view/see open connections, transactions not closed ... etc of a MS Sqlexpress database?

Thanks a lot - FOX

View 3 Replies View Related

SqlExpress Instance In Connection String Instead Of Full Sql 2005

Sep 27, 2006

Hello, I had started my project with the express edition, then I switched to the pro one. The problem is that in my webconfig I still have  .SQLEXPRESS and I don't know how to modify that to use the full version of Sql server. <add name="MyConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|MyDataBase.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient" /> When I look at the surface area manager I can see that I have 2 instances running : MSSQLSERVER and SQLEXPRESS.When starting Sql Server Management Studio I can connect to 2 servers: NEWDELL and NEWDELLSQLEXPRESS.And when I try to replace SQLEXPRESS by MSSQLSERVER in the connectionstring, then it doesn't connect.I remember having lost connection already when playing with all these tools, so I pay attention now ! That's why any help would be really appreciated ! Thank you. 

View 5 Replies View Related

Can't Start SQLEXPRESS So That I Can't Install Latest SQLEXPRESS Security Updates.

Mar 13, 2007

I can't start SQLEXPRESS.

The SQL ERRORLOG shows: Error is 3414, Severity 21, State 2 and says: "An error occurred during recovery, preventing the database 'model' (database ID 3) from restarting." Just prior to this, I get a warning: "did not see LP_CKPT_END".

Any thoughts why this might be and how I can fix this?

View 3 Replies View Related

Installing SqlExpress (Advanced Services) Will This Break Existing SqlExpress?

Sep 21, 2006

hiya,

I have sqlExpress and sqlServerManagementStudio on my XP pro box.

Will the installation of sqlExpress (Advanced Services) cause any problems?IS thereanything that I shold be aware of in advance?

many thanks,

yogi

View 3 Replies View Related

How To Install Windows Application(C#) With SQLExpress In A System Which Is Having SQLExpress Already?

Jan 19, 2007

Hi All,

I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.

If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.

But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.

Can anybody help me out .

Regards,

Doppalapudi.

View 2 Replies View Related

Sqlexpress Installer Doesn't Believe Sqlexpress Has Been Uninstalled

Mar 21, 2006

Because of numerous problems trying to get sqlexpress working, I uninstalled it with the intention of reinstalling (via Add or Remove Programs). However, now when I try to reinstall it, I get a message that the I am not making a changes so it won't let me install it.

I do have sql server 2005 developer's edition installed; is that the reason? and does that mean I cannot have both installed on the same machine?

View 1 Replies View Related

Convert A SQLExpress File Based DB Project To SQLExpress Server DB Project

Jul 1, 2006

Hi All,I've been struggling with this for hours...Could someone please advise me on how to convert my current File based SQL Server Express website to a Server based SQL Express one.Particularly interested in what I need to do in the SQL Express management tool, changes I need to make the projecvt itself and changes needed to get IIS to understand things have been changed.Thanks,Martin.

View 1 Replies View Related

Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object

Aug 23, 2006

I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

View 2 Replies View Related

Failed OLEDB Connection: Cannot Aquire Connection From Connection Manager

Feb 6, 2008

I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.

Thanks,

John T

View 3 Replies View Related

SQLExpress?

Aug 6, 2006

Hi
I'm pretty new to all of this. I downloded a starter kit and am a bit confised as to SQLExpress. I have SQL Server already installed and just wondering what the option are.
I am currently using Visual Web Developer Express Edition and in the config file data source is SQLExpress and can't go any further. I don't want to mess with my current setup so just want to get some sugestions first.
Anyway hope this makes sense.
Thanks
GP 

View 6 Replies View Related

Help With SqlExpress PLZ

Apr 2, 2007

I have just created a website with membership just using the standard SqlExpress auto generated file
Everything works fine until I upload it to webspace :(
I get the following Error
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I don't have SQL Server 2005 :(

View 3 Replies View Related

Just Asking About SqlExpress And Ado.net

Apr 3, 2007

if my SQl server/COnnection is "SQL EXPRESS"..Im using an Import name "Import System.SqlClient" on every web form that i have...
as well as other SQl command name like "SQLConnection,SQLCommand etc..."is this the correct that im using all sqlcommand in my webform???
well sorry for this im just new..and one more thing..can i include Ado.net on it if my connection is "SQLEXPRESS" just i said?
Thanks for the answer....

View 1 Replies View Related

/SQLEXPRESS

Jun 20, 2008

Hi

I am new to this forum .
I am running through few problems for sqlserver account settings .

I) My registery key entry for MSSQLserver just has a client folder .
2) My sql server configuration manager just has
sqlserver 2005 services , native client configuration and 2005 network configuration.


I can't see any server name or databases under it.


3)I normally work on EMS lite so I can see my ./SQLEXPRESS as server and databases under it and i can create logins etc ..I assigned db_owner role to one of my recent created database.
but when I try to connect it says :

The user is not associated with sqlserver connection.

5) i have sqlserver express service running, vss and sql server browser running.


I googled and searched for the solution and it says the authentication mode should be turned to mix mode form win authentication.

But from where. Have i missed some installation .I am able to connect to my other database from EMS.





Please help me out.
Thanks in advance
SJ

View 1 Replies View Related

SQLExpress

May 25, 2007

I am trying to write an application for a MSSQL database, using SQL Express,and Visual Studio (Express edition)I tried to connect to an existing database (named testing) but to no avail.Visual Studio claims the database does not exist.Any ideas?TIA--Q: What is the difference between a mathematician and a philosopher?A: The mathematician only needs paper, pencil, and a trash bin for hiswork - the philosopher can do without the trash bin...

View 3 Replies View Related

SP2 On SQLEXPRESS

May 27, 2007

Installation of SP2 in step "Feature Selection" shows SQLEXPRESS unchecked and can''t be edited/checked.
I tried it many times on different servers with different OSes, etc

Does it mean that SP2 for Expres Edition should be downloaded and applieŠ² separately?

View 1 Replies View Related

SQLExpress ASP.NET Confusion

Jul 19, 2006

Hello,I am just getting reaquainted with programming and all. I work in GIS mapping and am having diffilculty using  a ASP.net internet Map site and adding records to a needed database.I would like to be able to add records to a linked SQLExpress table when the user clicks on a map location. I adapted the following code snippet from an example that does what I would like only using an .mdb file.CODE:    // create connection to database                        var connection;                        connection = Server.CreateObject("ADODB.Connection");                        connection.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=OutdoorsExp;Data Source=NOLOGOSQLEXPRESS;");                        status = "Can't access 'FishSQL' table.";                        // create recordset                        var recordset;                        recordset = Server.CreateObject("ADODB.Recordset");                        recordset.CursorType = 1                        recordset.LockType = 3;                        recordset.Open("dbo.FishTable", connection);                                                status = "Can't append new record.";                        // append record for clicked location                        recordset.AddNew();                        recordset.Fields("LongitudeI").Value = xco;                        recordset.Fields("LatitudeI").Value = yco;                                                recordset.Update();                        recordset.Close();                        // release the .mdb file                        connection.Close();However, this does not add anything to the SQLEx table. What am I missing? I am thinking that it might have something to with the primary key.I had a table with way more columns then just lat/longs (as above) but only coded it to add data to the latitude and longitude fields. Nothing got added of course. Would have to add data to every field that doesnt allow nulls.How do I generate a random, unique ID for a primary key on the fly and for example add it to the appropriate column.Thanks you in adavnce for any insights.

View 1 Replies View Related

SQLExpress To SQL 2000

Jul 22, 2006

To be as brief as possible:I had Visual Studio 2005 installed with SQLExpress 2005.  worked reallll good :) I needed to convert an excell spreadsheet to SQL, so I migrated it to Access.  Then the upsizing wizard would not/could not create an sql table with the data.  Just would not take the data when the table was created. Argh.FINALLY figured out that the SQLexpress 2005 doesn't come with import/export.So I uninstalled the sqlexpress and installed SQL 2000 - Developer.  Veeola, able to convert and created the table I needed.Now Visual Studio 2005 won't let me touch the sql file, says it requires sql server express 2005.My ISP does not support SQL 2005 yet.  Is there anyway to get Visual Studio 2005 to work with SQL 2000 (only?)If I install SQLExpress over again, will it create problems when I go to publish my website, and more importantly right now, will anything bad happen when I reinstall sql express, or do I need to uninstall SQL 2000 first?  Thanks...

View 2 Replies View Related

Problem With Sqlexpress

Sep 29, 2006

hi:I set up a DSN via Adim tools, then I specify the connection string as "DSN=UserAppSample;Trusted_Connection=True".When I run my aspx page, it says: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL
Server]Cannot open database "UserAppSample" requested by the login. The
login failed. It asks for login, but I use windows authentication. So what is wrong with this? :(  

View 1 Replies View Related

What Is The Limitation Of SQLEXPRESS?

May 4, 2007

** For those 20 users (or fewer) who've read http://forums.asp.net/thread/1692306.aspx, I'm sorry that I ask the same question.Like I said above, what is the limitation of SQLEXPRESS, in terms of performance and scability?I'm creating a new webboard application that will replace the old one. I intend it to handle 200 concurrent users + 70000 records (9 years of data)The current system use Microsoft Access, which is reaching it's limit in performance and size. I took a look in the SQL Server product information page : http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx.It didn't tell me what I want, like how many connections it can handle, for example.If there are limitations that might cause my application to not reach the required specification (above), I may need to switch to MySQL. I've no intention buying a licensed SQL Server 2005.Thanks in advance.PS: Why there're so few users viewing my posts? Anyone know a more active forum that may help me?

View 9 Replies View Related







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