I have just upgraded to Microsoft SQL Server 2005 Express Edition with Advanced Services SP2.
Now I can't connect to my local database.mdf file.
When trying to open or doubleclick or expand my .mdf file the following message pops up:
Generating user instances in SQL Server is disabled. Use sp_configure 'user instance enabled' to generate user instances.
What is the solution for this problem?
I am facing a problem in connecting to the local database with server name as (local).
I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.
if anyone can help me what is the problem in this case it is highly appriciated.
:eek:
I want to use the Office Web Components (v10) PivotTable embedded in a web page. The examples and tutorials I've been able to find on MSDN all use the same architecture: The initial pivottable configuration is created by instantiating the object server-side and programmatically configuring it. The XMLDATA property is then read and sent to the client. At the client, script sets the XMLDATA property. So far so good, all makes sense. Then my problem: The PivotTable is then connected to Analysis Server using an http connection string (through IIS). As my users do not have database accounts, only application accounts, I cannot allow database connection information on the client. Trouble is, the PivotTable generates MDX queries when a user reconfigures the view, and there are no hooks (events or other means) to programmatically obtain the generated MDX query - a fact that is explicitly confirmed in MSDN documentation.
This clearly means that the PT must be connected directly to it's data source. So I thought I could just create a local MOLAP cube file and download it to the client (permissible as it runs as a trusted application). But nowhere can I find any example or documention on how to do this.
This is driving me slightly insane and I have little hair left now; if anyone knows how to do it or where to find proper PivotTable documentation (rather than a collection of examples that do something else from what I need to do!) then help is greatly :p appreciated!
Dag
DBconn.cs
private DBConn() { // // TODO: åœ¨é€™è£¡åŠ å…¥å»ºæ§‹å‡½å¼?的程å¼?碼 // this.Server=Property.getProperty("DBServer"); this.port=int.Parse(Property.getProperty("DBPort")); this.User=Property.getProperty("DBUser"); this.Pwd=Property.getProperty("DBPwd"); this.db=Property.getProperty("DBDatabase"); this.ConnectionString="server=" + this.Server+","+this.port+";database="+this.db+";uid="+this.User+";pwd="+this.Pwd+";Connect Timeout=60"; }
--------------------------------------------------------------------------------------------------------
propetry.config
<property name="DBServer" value="127.0.0.1" /> <property name="DBPort" value="1433" /> <property name="DBDatabase" value="CSLC" /> <property name="DBUser" value="CSLCUser" /> <property name="DBPwd" value="resslc" />
I use this way to call my connecting string , but I can't connect to my local DataBase , I trid to modify the propetry.config to coneect to other DataBase on other Server it works
only when Connecting with my Local DataBase , it not work...
this problem have been troble me more than 3 weeks... ask many people no one can resolve this problem...
when I am at home . I can't work... because I can't connect to the Server when I'm in office..
pleaes help... thank you very much
Hello,
After restarting the machine, the sql 2000 won't start.
- I'm using local (no domain)
- administrator account
- sql agent is started, but cannot connect
a connection could not be establish to (local)
please verify the sql server is running and check your...
sql log below:
2008-02-07 11:34:53.04 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2008-02-07 11:34:53.04 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-02-07 11:34:53.04 server All rights reserved.
2008-02-07 11:34:53.04 server Server Process ID is 3088.
2008-02-07 11:34:53.04 server Logging SQL Server messages in file 'C:Arquivos de programasMicrosoft SQL ServerMSSQLlogERRORLOG'.
2008-02-07 11:34:53.06 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2008-02-07 11:34:53.14 server SQL Server configured for thread mode processing.
2008-02-07 11:34:53.17 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2008-02-07 11:34:53.17 server Attempting to initialize Distributed Transaction Coordinator.
2008-02-07 11:34:55.21 spid4 Starting up database 'master'.
2008-02-07 11:34:55.48 spid4 Server name is 'SUPORTE_SERVER'.
2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 23
2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 31
2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 32
2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 34
2008-02-07 11:34:55.48 spid5 Starting up database 'msdb'.
2008-02-07 11:34:55.48 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2008-02-07 11:34:55.48 spid6 Starting up database 'model'.
2008-02-07 11:34:55.49 spid8 Starting up database 'pubs'.
2008-02-07 11:34:55.49 spid10 Starting up database 'Northwind'.
2008-02-07 11:34:55.49 spid11 Starting up database 'Umuarama'.
2008-02-07 11:34:55.49 server SQL server listening on 192.168.0.101: 1433.
2008-02-07 11:34:55.51 server SQL server listening on 127.0.0.1: 1433.
2008-02-07 11:34:55.51 spid12 Starting up database 'adm_clube'.
2008-02-07 11:34:55.51 spid13 Starting up database 'Geracao'.
2008-02-07 11:34:55.51 spid14 Starting up database 'Sim_Externo'.
2008-02-07 11:34:55.51 spid15 Starting up database 'OPEN'.
2008-02-07 11:34:55.53 server SQL server listening on TCP, Shared Memory, Named Pipes.
2008-02-07 11:34:55.53 server SQL Server is ready for client connections
2008-02-07 11:34:56.25 spid6 Error: 9003, Severity: 20, State: 1
2008-02-07 11:34:56.25 spid6 The LSN (5:348:1) passed to log scan in database 'model' is invalid..
2008-02-07 11:34:56.84 spid10 Starting up database 'SISCONTACOR'.
Thanks
I am trying to run MS SQL Server Management Studio Express. According to what I read, I can connect by selecting Database engine, then on server name, I put my computer name sqlexpress. I am using Windows Authentication. Every time, I get:
TITLE: Connect to Server
------------------------------
Cannot connect to kennethsqlexpress.
------------------------------
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
------------------------------
What am I doing wrong? Thanks for helping me to stop pulling my hair out.
Hi,
I'm trying to work on a database when I'm not connected. I can't figure out how to get a local copy of a database.mdf that I created on the server, onto my hard drive, using SQL Management Studio Express. Does anyone have any suggestions? I'd be forever in your debt. Thanks
I have made a small asp.net project which uses a local database file as a part of the project. The project is running fine om my local machine, but when I upload it to the remote server, the login fails for the server.
I suspect this is can be solved by using sqlserver authentication. But I have now spent a lot of time trying to configure the database file to use this authentication mode. As I see it there are three possible solutions to the problem.
use management studio express to configure the local mdf file (Ecxept that I cant find out how to connect to the mdf-file) and from here change the authentication method to sqlserver authentication.
use Visual Web developer to change the authentication method (but how???)
make the windows authentication work on the server (this would probably require that mannamgement studio express connects to the remote database. (Same problem as no 1)
Help will be higly appreciated.
Bjarke
Hi all,
Currently, my (small) intranet site is storing it's data on a remote SQL server. The danger with this, as has happened several times now, is that the application is twice as vulnerable; if either the webserver or the dataserver malfunctions or is unreachable, the application won't work.
I only recently discovered the possibility to use local database files (MDF files), and this seems like a much better solution for my site. But now I want to transfer the tables that are residing on the dataserver, to the MDF file. The database only contains tables. How do I handle this? I do not have access to the dataserver, only to a few databases that are residing on it. Is this possible using Visual Studio 2008? I have read about a "Bulk Copy Program" (bcp) which is included with SQL Server, but I cannot find a download for just that application.
Or is this totally not the way to go? I've discovered MDF files are a bit more problematic with concurrent connections; having tables open in Visual Studio results in "Site offline" or "Cannot open database" error messages on the website. Problems I've never had to deal with using SQL Server, but they are only minor problems.
Thanks,
Peter
I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!
View 6 Replies View RelatedI am using the following C# code to establish a SQL connect to a SQL database file:
// connection string
// attach a SQL database file to a local SQL server express instance
string _connectionString = @"Server=.SQLExpress; AttachDbFilename=C:BalanceDatabase_1.mdf; Trusted_Connection=Yes; User Instance=True";
// using System.Data.SqlClient;
SqlConnection _sqlConnection = new SqlConnection(_connectionString);
// open the connection
_sqlConnection.Open();
// do something
// close the connection
_sqlConnection.Close();
So far, the connection works fine.
However, next, I want to copy the database file to another folder. So the following codes:
// source database file name
string sourceDatabaseFileName = @"C:BalanceDatabase_1.mdf";
// target database file name
string targetDatabaseFileName = @"D:BalanceDatabase_1.mdf";
// copy database file
System.IO.File.Copy(sourceDatabaseFileName, targetDatabaseFileName, true);
Then the program came with runtime exception: "IOException was unhandled: The process cannot access the file 'C:BalanceDatabase_1.mdf' because it is being used by another process."
Is it because the database file was sill attached to the local SQL Server express instance? What can I do to bypass this problem? Detach the database file? or dispose the local SQL Server express instance?
Many thanks indeed!
Unfortunately I was sent to this product by my Hosting Site since all I was trying to do was Create and Manage a User Login with authentication to my subsites in MS Frontpage. (rant: Why doesn't Frontpage support this technology???)
Anyway, I have now spent (wasted?) 8 hours downloading, installing, and tyring to configure SQL Express along with MS Visual Web Developer Express for ASP.NET 2.0 ... For the life of me I can't find detailed configuration informatin and setup information to build a SIMPLE database to connect to the VW product. Folk: this HAS to be simpler to do than what you present in the product! This is way too difficult to deal with compare with frontpage.
Is there a simple "how to" link someplace that is specific enough to preclude me from uninstalling this entire suite ????
Hi,
I am a beginner on using SQL Server Express. I have two different questions. Here is the first:
I've developed a simple C# application in Visual Studio 2005 that connects to a SQL Server database file. In the application I connect to the database using this connection string:
@"Data Source=.SQLEXPRESS;AttachDbFilename=C:Databasesmydatabas.mdf ;Integrated Security=True;Connect Timeout=30;User Instance=True";
and It works perfect.
But when I move the database file(and the corresponding log-file) to another computer it fails. I've changed the connection string to this
@"Data Source=.SQLEXPRESS;AttachDbFilename=\myserverDatabasesmydatabase.mdf ;Integrated Security=True;Connect Timeout=30;User Instance=True";
This is the error message I get when I try to open the database
The file \myserverDatabasesmyDatabase.mdf is on a network path that is not supported for database files.An attempt to attach an auto-named database for file \myServerDatabasesmyDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Both computer runs Windows XP SP2.
My second question is:
When I deployed my solution to my production PC(witch also runs Windows XP SP2, .NET Framwork 2.0 is installed on the computer) .When I then tried to run the application I did get this error message
An error has occured when establishing a connection to the server. When connection to a SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remomte conections.....
Appearently I cant treat SQL Server database files in the same way as Access-files, or?
Jan Olsson
Hello Friends!!
Is there a way to connect to mdf database files using java language?
I use the code below to connect to my oracle database... but now i want to use java code to connect to mdf database file...
Is there a way to do it?
What will be the connection string in that case?
Thanking you in advance..
/* THIS CODE Connects to oracle database using java language*/
Connection con = null;
Statement st =null;
Statement batchStm = null;
System.setProperty("jdbc.drivers","sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Registred Driver");
//Conecting to dbase
con = DriverManager.getConnection("jdbcdbcbSourceOra","scott","tiger");
System.out.println("Got the Connection");
I recently created a program that connects to a Microsoft SQL database that was stored on my computer and it worked fine. As soon as I tried to connect to the same database via a network drive I got an error stating that "The file Y:Filename.mdf is on a network path that is not supported for database files.". I can't seem to get it to work, if anybody has any ideas what I'm doing wrong I would appreciate your help.
Don
Hello, we have the hosting account with GoDaddy Server. We have using Visualstudio.net and MSSSQL Server 2005.
For hosting the files for the remote server ( Godaddy ) we are using FTP Cute client to upload the files. For Uploading a database they given a seperate login and we are hosted my data as a Transact SQL File. Up to this its going fine.
After that I want to retrieve my data from GoDaddy Database server. They are not allow the remote connections directly. But they told to use the File DSN to retrieve the data from thier server ( GoDaddy Server ). I don't Know how to use thier File DSN to connect My ASP.Net 2.0 Application to thier GoDaddy Database Server.
If I asked to GoDaddy Support team they are sending this file.
Connecting to a Microsoft SQL Server Database Using ASP/ADO
Hey Guys,
I have a SQL connection string question. In my web.config I don't know what to put for the server. I have SQL Server 2005 installed locally.
<connectionStrings><add name="database" providerName="System.Data.SqlClient" connectionString= "server=whatgoeshere?;database=test;uid=sa;pwd=password" /></connectionStrings>
I'm using VS 2005.
Thanks in advance.
-Marc
hi..
i am trying to run my asp project using my iis in winxp and installed a sql express 2005 and wheni try to connect using http://localhost/myproject i encounter this error
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
am i missing some permission settings in sql express?
thanks
I have just recently installed MS SQL Server 2005 Developer edition. I have installed SP2.
Today when I try to connect via Management Studio, 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: 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.) (.Net SqlClient Data Provider)
I installed it as a default instance.
I recently added a login with dbo privileges. I have tried logging in with that sql account and also with windows authentication to no avail.
Thank you for any help.
Hello,
I am unable to connect to my local sql server express db. I would like to test my app and its not connecting.
It works when I use windows authtentication Trusted_Connection=yes
but not when i use: user id=sdvaid; password=sdavid
Const connectionString = "Data Source=SDAVIDSQLEXPRESS;Initial Catalog=intranet;user id=sdavid;password=sdavid"
Dim conn As SqlConnection = New SqlConnection(connectionString)
Dim cmd As SqlCommand = New SqlCommand("select * from Users", conn)
cmd.CommandType = CommandType.Text
Try
conn.Open()
cmd.ExecuteNonQuery()
Catch ex As Exception
Response.Write(ex.ToString())
Finally
conn.Close()
End Try
thanks.
Here is the error: "SQL Server does not exist or access denied."
Please advise...
Hi Everyone
I am at the stage of architecting my solution
My goal is to develop the system on a windows application and pda
There is a central server which will create a publication called inventory
The laptops which host the windows application will be subscribers to the central server using merge replication
The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server
I have been reading for days and I am still unsure whether this is possible to do.
I know Appforge provide a conduit for palm to access synchronization but not local sql databases
I would appreciate your help immensley
I have a page that connects to SQL server. It works fine when running in local host but when I publish to the server, I get the following: 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)
Any ideas on where to start? Thanks,Mark
Hi all,I having problems connecting to my local database through my asp.net site. I'm able to connect to the database using Query Analyzer with the following connection properties:Server: localSql Server Authentication: checkedUser Name: saand the Password is left blankThis is the connection string i'm using on the website:Data Source=local;Initial Catalog=myDatabaseName;User ID=sa;Password=;This is the error i'm getting: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) Any suggestions appreciated.Thanks
View 1 Replies View RelatedI have a SQL Server 2005 instance which resides on a dedicated server hosted by a third party. I am able to connect to this server through my local SQL Management Studio, however, my local ASP.NET 2.0 web application cannot connect. I get the error below. The connection string I use is formatted as...
Connection String:
Server=thesever;uid=myuserid;pwd=mypassword;database=mydatabase
Error:
Failed to connect to database: 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 hosting providr claims that the SQL Server configuration settings are as they should be as fars as TCP/IP and Named Pipes are concerned. Does anyone know what might be going on?
Hello, I need help to connect to my local sql express db in visual studio 2003 in vb.It currently works with the production db information and I need to test a few things, So i'd like to point it to the local db.It works this way:Const CONN_STRING = "server=johndoe;user id=john;password=doe;database=johnd"Dim conn As SqlConnection = New SqlConnection(Me.CONN_STRING)conn.Open()I want to point it to my local db and it doesn't connect. Dim connectionString As String = "Data Source={myusernameSQLEXPRESS};Initial Catalog=johnd;Trusted_Connection=yes" Dim conn As SqlConnection = New SqlConnection(connectionString) Try conn.Open() Catch ex As Exception Response.Write(ex.ToString()) End Tryand even that doesn't work.When i go to my sql server 2005, it saysMYUSERNAMESQLEXPRESS (SQL SERVER 9.0.3042 - theworknetworkmyusernamewhat am i doing wrong ?Thanks.
View 7 Replies View Relatedi have problems connecting to the local server on my laptop. i ahve used the following code but it gives me an error saying login flaied for user "sa" or "sekhar".
i tried using the username and password i use to log onto my computer. but it doesnt work.
can anyone tell me how to do it?
the code is typed is
connection = new sqlconnection("server=localhost;uid=sekhar;pwd=sekhar;database=chandu")
........................
......................................
...............................
connection.open()..................i have all the next statements correct.
my username is sekhar and the password is sekhar too but it gives me an error.
somebody help me
Thank you
sekhar
I am trying to set up a new sql server registration to my local computer.
and there's this error - "General Network Error,Check your network documentation.ConnectionOpen(Connect()).
I have already tried to register the server(the available servers field)
are entered as my computer name,local IP address,(local),"."(ignore the double quote), and even 127.0.0.1,but the same error occured.
When i first installed it into my computer, it work for a while, but ultimately MSSQLServer and SQLServerAgent service stopped even though the MSDTC service is still running
For ur info, the installed software is MSSQL7 7.0 Desktop Edition, in Windows 98 Platform
Hi !! everbody i have a problem in sql executive ( 6.5 version),whenever i am using cmd.exe for running scheduled task it runs fine but if i am using TSQL task type to run a task then it gives error and says that 'unable to connect to server '(local)'.
our this TSQL task type was running previously but now for last 5 days itis not runnig.
Your reply would be highly appreciated
Pl. reply as early as possible
thanks in advace
from
rajesh
I open II services.
From this point I right click on information services and clicked "connect to computer" and located mine. When I hit "ok", I got "This computer is not running Internet Information Services Ver 4 or higher".
IIS6 is starting, it just won't connect to local computer.
Previously someone said to post the event logs. I can't find them. Where are they??
Thanks
All help is appreciated.
Thanks
Hi
I had Sql Server 2005 installed on a machine of mine and was able to connect to the local, however I had to unistall it. Recently I put it back on the machine and found that I was no longer able to connect to the local server.
Does anyone know why this has happened and how it can be resolved?
Thanks
hello,
Sql server type: database engine
server name:
authentication: sql server authentication
login: sa
password: xxxxx
I remember the server name being sqlexpress (I think that was the default name during the install).
OR are they asking for my computer name? because I tried that also and it gave me an error saying "the default installation doesn't allow remote connections"
I have SQL Express running on my laptop but are unable to connect to the default database paulm-laptopsqlexpress
When I try to connect I get the error message
TITLE: Microsoft SQL Server Management Studio Express
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)
Everything is on my laptop whcih is running Vista Business as an administrator
Any ideas why,
Thanks Paul
During my install of SQL Server 2005 Developers edition, I got an error that Reporting Services could not connect to SQL Server. After completing the installation I was unable to connect to the local service using an domain account (that's an admin on my machine) or the SA account. I've retried uninstalling and reinstalling numereous times and no success. I was able to login to the IP addess with the SA account only.
I did set the config for remote access...
Shared Memory is Enabled
Named Pipes is Enabled with Pipe Name = \.pipesqlquery
TCP/IP is Enabled, Listen All, IP Address active and enabled for 127.0.0.1 and network address, TCP Dynamic ports not set
When I login with an IP address and an local admin account I get this error:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
When I try to login to the machine name with a local admin account I get this 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
When I try to login to the machine name with the SA account I get this 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
I can login with the SA account using the IP address.
I can login with a local admin account for 127.0.0.1
Any ideas what's going on? Why doesn't uninstalling and reinstallingh fix this? Is there a tool that will purge the registry of all remnants after an uninstall? Any help would be appreciated.
Tony Zoccolillo