Vpn Sqlexpress Connections
Oct 10, 2006
I set up vpn along with lan setup on my serverbox with sqlexpress.
I set up vpn connection on my laptop.
When I use the LAN, I connect fine.
When I use VPN, I cannect fine
When I disconnect from VPN and Try to connect via LAN I get ..
"error: 26 - Error Locating Server/Instance Specified" connecting to sqlexpress...it can't find the instance. So I have to restart the sqlexpress and browser. Then I can connect.
Any Ideas as to why this is happening.
View 3 Replies
ADVERTISEMENT
Feb 21, 2007
I have a SQLExpress Database that I can connect to from a C# application and seperately from an application via 'OBDC' with NO problems. Both applications are running on the Local PC running XPpro.
However, I cannot connect to the same database from both applications at the same time!
Is there a way around this ?, is it a restriction of the Express version ?
View 3 Replies
View Related
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
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
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
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
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
May 17, 2005
Hi there,
Here we have got a
asp.net application that was developed when database was
sitting on SQL server 6.5. Now client has moved all of their databases
to SQL server 2000. When the database was on 6.5 the previous
development team has used oledb connections all over. As the databases
have been moved to SQL server 2000 now i am in process of changing the
database connection part. As part of the process i have a login
authorization code.
Private Function Authenticate(ByVal username As String, ByVal password As String, ByRef results As NorisSetupLib.AuthorizationResult) As Boolean
Dim conn As IDbConnection = GetConnection()
Try
Dim cmd As IDbCommand = conn.CreateCommand()
Dim sql As String = "EDSConfirmUpdate" '"EDSConfirmUpdate""PswdConfirmation"
'Dim cmd As SqlCommand = New SqlCommand("sql", conn)
cmd.CommandText = sql
cmd.CommandType = CommandType.StoredProcedure
NorisHelpers.DBHelpers.AddParam(cmd, "@logon", username)
NorisHelpers.DBHelpers.AddParam(cmd, "@password", password)
conn.Open()
'Get string for return values
Dim ReturnValue As String = cmd.ExecuteScalar.ToString
'Split string into array
Dim Values() As String = ReturnValue.Split(";~".ToCharArray)
'If the return code is CONTINUE, all is well. Otherwise, collect the
'reason why the result failed and let the user know
If Values(0) = "CONTINUE" Then
Return True
Else
results.Result = Values(0)
'Make sure there is a message being returned
If Values.Length > 1 Then
results.Message = Values(2)
End If
Return False
End If
Catch ex As Exception
Throw ex
Finally
If (Not conn Is Nothing AndAlso conn.State = ConnectionState.Open) Then
conn.Close()
End If
End Try
End Function
''' -----------------------------------------------------------------------------
''' <summary>
''' Getting the Connection from the config file
''' </summary>
''' <returns>A connection object</returns>
''' <remarks>
''' This is the same for all of the data classes.
''' Reads a specific
connection string from the web.config file for the service, creates a
connection object and returns it as an IDbConnection.
''' </remarks>
''' -----------------------------------------------------------------------------
Private Function GetConnection() As IDbConnection
'Dim conn As IDbConnection = New System.Data.OleDb.OleDbConnection
Dim conn As IDbConnection = New System.Data.SqlClient.SqlConnection
conn.ConnectionString = NorisHelpers.DBHelpers.GetConnectionString(NorisHelpers.DBHelpers.COMMON)
Return conn
End Function
in the above GetConnection() method i
have commented out the .net dataprovider for oledb and changed it to
.net dataprovider for SQLconnection. this function works fine. But in
the authenticate method above at the line
Dim ReturnValue As String = cmd.ExecuteScalar.ToString
for some reason its throwing the below error.
Run-time exception thrown : System.Data.SqlClient.SqlException - @password is not a parameter for procedure EDSConfirmUpdate.
If i comment out the
Dim conn As IDbConnection = New System.Data.SqlClient.SqlConnection
and uncomment the .net oledb provider,
Dim conn As IDbConnection = New System.Data.OleDb.OleDbConnection
then it works fine.
I also have changed the webconfig file as below.
<!--<add
key="Common" value='User ID=**secret**;pwd=**secret**;Data
Source="ESMALLDB2K";Initial Catalog=cj_common;Auto
Translate=True;Persist Security Info=False;Provider="SQLOLEDB.1";'
/>-->
<add key="Common" value='User ID=**secret**;pwd=**secret**;Data Source="ESMALLDB2K";Initial Catalog=cj_common;' />
Please help. Thanks in advance.
View 4 Replies
View Related
Jul 20, 2005
Just a quick question about connection management. My application willnever need more than 1 or 2 connections about at any given time. Also, I donot expect many users to be connected at any given time. For efficiency, Iwould like to keep connections alive throughout the lifetime of the objectsrequiring them, rather than opening a new connection, executing code andthen closing it again. What is the most efficient way of doing this?Should I perform the open/close or just one open when I create the objectand a close when I dispose of it?
View 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
Oct 2, 2007
i'm using sqlexpress edition for my application and i'm wondering whether i will be able to execute the below sql statement
use masteralter database <dbname> SET ENABLE_BROKER
when i execute the above two lines its executing from last 30+ minutes...
i'm wondering will that support in sqlexpress edition ?
also, in order to use sqldependency do i have to enable broker service?
thanks.
View 2 Replies
View Related
Nov 28, 2005
Ok it seems to me that if you use the ms recommended code to connect your apps using the app_data folder etc, that the dbs never show up in the SQLExpress manager.So I can't back them up like I can databases I connect to SQLExpress the 'old fashioned way'. Only 2 out of 6 dbs are visible in SQLExpress manager.What is the proper way to do this?Thanks,Jamey
View 3 Replies
View Related
Dec 6, 2005
1. Is there a white paper on how to upgrade an SQLExpress DataFile to a SQLServer attached database?
2. More importantly: Is there a way to upgrade a Beta 2 SqlExpress database to a RTM version? This lack of compatibility between beta 2 and RTM is killing me. Are their any resources for this transformation? Would be great!
View 3 Replies
View Related
Apr 17, 2008
As of right now I have two networked machines. I have a sql database on one that I have no problem connecting to, but I cannot connect to the database from the second machine.
From the second machine, I've come up with this connection string after all my research...
"server=[MACHINE_NAME]SQLExpress;databse=[NAME];User ID = sa;Password=[PASS]"
I keep getting a cannot connect to database error.
Any ideas?
View 5 Replies
View Related
Apr 23, 2008
I know this isn't exactly SQL help, but I alwasy get great help here and thought someone might know why I'm having problems. I'm trying to map to a drive where I have a SQLExpress database on another computer within a workgroup. This is the cmd line I'm using...
NET USE * \XPPRO1SQLExpress /USER:Admin /SAVECRED /PERSISTENT: YES
I'm thinking the problem is with the * (which names the new drive with the next available letter), or that I have to use a password. Everything I've found says nothing about specifying a password though.
The error message I get says "A command was used with conflicting switches."
View 1 Replies
View Related
Dec 3, 2005
I just reinstalled SQLExpress and all the dbs that I created are no more linked. The files still exist in the folder where the current version stores dbs (...Microsoft SQL ServerMSSQL.1MSSQLData) but they are not "linked" (don't know the right term).
Is there anybody who could help me how to "relink" these dbs to the actual .SQLExpress instance?
Thank you very much for any help!
Regards,
Fabian
my favorit hoster is ASPnix : www.aspnix.com !
View 2 Replies
View Related
Feb 14, 2006
Hi friends
I insalled Visual Studio 2005 standard edi on XP machine. as you all know it also installs sqlexpress. i want to uninstall this sqlexpress as i also have sql server 2005 standard edition on my machine.
but i dont see any option to uninstall in add/remove programs or in start menu for sqlexpress.
any ideas on this ?
Thanks for your help.
Cheers
View 13 Replies
View Related
Sep 1, 2006
I made a big mistake and deleted this program and now I cannot reinstall it. I get error messages stating that an instance is already on my machine and I need a unique name to restart install. I also get messages that say to install from the command line but I cannot get there the only access I have is error reporting. Is there any way I can make a FREASH install of this program????
View 2 Replies
View Related
Jul 31, 2007
Hello,
I have finish building my ASP.NET site using VS 2005 and it compile just fine. Than I try hosting it to the web via IIS v5.1 and I am getting permission error from SQL express.
I have posted a detail question in experts-exchange.com and since you need a user account to even view the thread, I have taken the liberty to save the thread as .html file and host it to my ISP site. You can see the detail problem I am having here: http://users.accesscomm.ca/mm/EEdetail.html
I am going to list out some stuff I have done:
1. I have two database that need access, the ASPNETDB.mdf for user login and another database (PhotoDataBase.mdf) to store information relating to the photo I uploaded to my ASP.NET site.
2. I have already follow this How to site: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx and setup:
- TCP/IP enable, as shown here:
- I have started SQL Browser service
- The firewall part I am not so sure about. I am currently using Zonealarm....
3. I have installed SQL Server Management Studio Express(SSMSE) and attach the two database to it.
4. I have set SSMSE server properties to accept both SQL and window authentication.
5. I have made sure that both database "read only" setting to false
6. I have setup SQL login with User ID = SQLLOGIN
Here is the original connection in web.config:
<add name="ConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|Da
taDirectory|PhotoDataBase.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
and here is the new connection I just type in web.config that replace the original one:
<add name="ConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|PhotoDataBase.mdf; Server=MINGDESKTOP; Integrated Security=False; uid=SQLLOGIN; Password=XXXXXX;"
providerName="System.Data.SqlClient" />
and the error i get are the follow:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
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.
7. I did haven't done much to ASPNETDB.mdf yet and the error i get right now are the following:
________________________________________
__________________
Server Error in '/' Application.
Cannot open user default database. Login failed.
Login failed for user 'MINGDESKTOPASPNET'.
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: Cannot open user default database. Login failed.
Login failed for user 'MINGDESKTOPASPNET'.
_______________________________________________
Please help! I am really running out of ideas.... and I need to have this setup in a few days....
Thanks!
View 17 Replies
View Related
Dec 1, 2006
Hi, I'm using Microsoft SQL Sever Management Studio Express. But all of a sudden, if I clicked connect button, the messageBox pops up and it doesn't let me connect. It says "TITLE: Connect to Server
------------------------------
Cannot connect to YOUR-4105E587B6SQLEXPRESS.
------------------------------
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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I didn't have such a problem before. If someone could help to solve to this problem, I appreciate it. Thanks.
View 5 Replies
View Related
May 18, 2008
I am a novice at working w/SQL and am trying to learn on my own... I download SQLExpress and installed it. However, I received a warning message that Internet Information Systems was not installed or enabled. I checked cpanel and it was not there. Figured out that I needed to check the windows components and attempted to enable it. I was asked for my XP Pro discs (which I can't find of course) in order to load admxprox.dll. How can I get a copy of that file so I can move forward???
View 13 Replies
View Related
Feb 26, 2007
Hi, please can someone be so kind and tell me the fastet way to get the GUID of the running SQLExpress instance ?
Sincerely,gonzo883.
View 5 Replies
View Related
Nov 20, 2007
Hi, Mike, et al,
First of all, I am a self taught programmer, and a Sql Neophyte, and know just enough to get confused (or in trouble). I have a TabletPC app that uses SqlExpress, installing as 'Click Once'. Works great on XP, but my app comes to a screeching halt on Vista, because of the permissions/contact network administrator issue. I read Mike's post (dated a year ago, Oct 06) about using SSMSE to create a new Login with sysadmin rights for the current user. Long story short, completed it successfully, but it didn't work.
I have been browsing posts here on the subject, but I am confused. Does my Vista user need to install SP2? Will that fix the problem? I am sorry, but some of the posts on this subject are over my head.
Could I prevail on one of the moderators to point me in the right direction, or to explain in v-e-r-y b-a-s-i-c terms what I need to do to help my Vista users access my SqlExpress DB?
Many thanks!
Steve
View 11 Replies
View Related
Mar 3, 2007
I had sql express and microsoft express accounting working fine on xp. When I updated to vista and reinstalled sqlexpress with sp1 and management express sp1, I can not get the server to register. Any command I click gives error message "this type of initializer <module> threw and exception". Also when I tried to install accounting from office 2007 cd, will not install giving same message. Ihave uninstalled and reinstalled sql express w sp1 several times with no success. I can find no reference to this error message anywhere. Anybody got an idea where I can do to get this to work properly? Thanks in advance.
View 3 Replies
View Related