If All What I Used Is The Express Version - Is It Possible To Connect And Use The Sql.s Express Form The Vs. Express
Apr 14, 2008
Hello
I got a sql server express that i am trying to connect form win or web forms(2.0) €“ express as well.
My problem:
Can not connect to the server in any way!
Even the designer cont find any sql server on my machine; for example "the data source configuration manager" (gui) in enyn way its can not find the sql server express (2005)
So my question is:
if all what i used is the express version - is it possible to connect and use the sql.s express form the vs. express
View 10 Replies
ADVERTISEMENT
Feb 25, 2008
I just got a dedicated server to run my websites and SQL Server and MS SQL 2005 Express was installed as it will be more then enough to handle the needs of my DBs right now. The problem I am getting is that when I try to connect to the server from Management Stuido Exrpess (from the server it's self) I recive this error:
quote:provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server Microsoft SQL Server, Error: 2
And when from a remote computer I get:
quote:provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server Microsoft SQL Server, Error: 53
I have gone into the Service Area Configuration and made sure that it is set to accept TCP/IP and Named Pipes connection from remote computers and then restarted the dataebase engine.
Can anyone help me? Since this is a dedicated server I have to pay for there support and want to see if I can avoide that
--
If I get used to envying others...
Those things about my self I pride will slowly fade away.
-Stellvia
View 3 Replies
View Related
Feb 1, 2007
Anyone know how to fix this error:
System.Data.SqlClient.SqlException was unhandled
Class=16
ErrorCode=-2146232060
LineNumber=65536
Message="Directory lookup for the file "C:Documents and Settingszimmerman_eMy DocumentsVisual Studio 2005ProjectsMGM_REPORTSMGM_REPORTSImportFile.mdf" failed with the operating system error 5(Access is denied.).
Could not attach file 'C:Documents and Settingszimmerman_eMy DocumentsVisual Studio 2005ProjectsMGM_REPORTSMGM_REPORTSImportFile.mdf' as database 'dbname'."
Number=5133
Procedure=""
Server=".SQLExpress"
Source=".Net SqlClient Data Provider"
State=1
StackTrace:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at MGM_REPORTS.DbConnect.InsertSQL(String[] Values) in C:Documents and Settingszimmerman_eMy DocumentsVisual Studio 2005ProjectsMGM_REPORTSMGM_REPORTSDbConnect.vb:line 149
at MGM_REPORTS.DbConnect.btnConnectDB_Click(Object sender, EventArgs e) in C:Documents and Settingszimmerman_eMy DocumentsVisual Studio 2005ProjectsMGM_REPORTSMGM_REPORTSDbConnect.vb:line 21
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at MGM_REPORTS.DbConnect.Main() in C:Documents and Settingszimmerman_eMy DocumentsVisual Studio 2005ProjectsMGM_REPORTSMGM_REPORTSDbConnect.vb:line 158
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
View 4 Replies
View Related
Apr 1, 2006
I have a database which was created in a beta release of SQL Server Express. It was also create when I had the .Net Framework 2.0 Beta installed.
Since then, I have installed .Net Framework 2.0 (Current Release) because that is what was required for MS SQL Server Management Studio Express.
When I try to connect to the DB now it says Cannot connect to server.
I also have the mdf/ldf files. When I try to attach them on another computer running the latest version of SQL Server Express it says:
Database 'Name' connot be upgraded because its non-release version (587) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this vertion of sqlservr.exe. You must re-create the database....
Any ideas how i can get the mdf/ldf files converted over? Or how I can attach the the ealier version of sql server express?? thanks.
View 1 Replies
View Related
Apr 23, 2008
Hello,
I am creating a windows application that is not going to be used in a controlled environment like a LAN or some other network, so I want to include a local database in the install of this app. Ideally, I would like to use SQL 2005 Express like you would MSDE or Access, but I am not sure if the user must have SQL Server installed on their machine in order for this to work and I don't have a machine without it to test on.
Any help on this is greatly appreciated.
Thanks,
Derek
View 1 Replies
View Related
Sep 28, 2006
Everything was working fine. I have been able to connect using windows authentication. Then, I went into the ODBC manager to add a data source and it failed to connect so I went back into the Server management studio to modify users. After doing this I now get an error when I try to conenct the management studio to the SQL server.
I wasn't modifying the login for my windows account that I normally use, I was modifying a different one, however I now get the message "An error has occured while establishing a connection to the SQL server. This kind of problem can ocure because the default behavior of the server does not support all connection methods" blah blah.
Does anyone know how I can attach to the server? Or, do I need to somehow remove the server and create a new one? How would I do that?
Thanks in advance for any input.
View 1 Replies
View Related
Mar 10, 2006
I've seen the following error posted when people try to connect to their server via their applications but didn't see anyone having problems when trying to connect with SQL Server Management Studio Express. Am I missing something here? This is the 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 2)>>The server is not remote so I don't see why I need to enable remote connection. I am also using the default connection settings.
View 3 Replies
View Related
Feb 24, 2007
On my home machine without permanent network connections enabled, I cannot get the Management Studio connect to the database server. Always get this error:
Cannot connect ot MPLIAMSQLEXPRESS
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, erro: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)
I have used the SQL Surface Area Configuration Tool to reset the defaults to allow remote connections, stopped and restarted the server, but still get the same message.
Please help.
View 12 Replies
View Related
Jan 16, 2008
Hey all! I am new in this form and also new with the SQL serve. I have installed that free express edition of SQL server 2005 and when i am trying to connect to server from my C#.net application i am not able to do it and when i am trying to degug it gives me the error that is the user is not SQL thrusted user. I am able to connect directly thru SQL server using this userid and password but not thru VWD 2005 Express application.
I have read online that so many people are having that problem. so is it the problem of swl server Express edition or do i have to make some setting to connect to the application.
Please please please please someone guide me . I am stuck here in the beginning only. I would really appreciate it.
the code that i wrote is here:----
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
}
}
protected void Submit_Click(object sender, EventArgs e)
{
String querry;
SqlDataReader dbread;
try
{
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["Conn1"]);
SqlCommand comm = new SqlCommand();
conn.Open();
querry = " Select password from login where userId='" + TxtUser.Text + "'";
comm.CommandText = querry;
comm.Connection = conn;
dbread = comm.ExecuteReader();
dbread = null;
if (dbread.HasRows)
{
while (dbread.Read())
{
if (dbread["password"].ToString() == Txtpwd.Text)
{
Response.Redirect("home.aspx");
}
}
Response.Write("Your Password Doesn't Match");
}
else
{
Response.Write("Your User Name Is Wrong");
}
conn.Close();
}
catch (Exception ex)
{
Response.Write(" This is an Error - " + ex.Message );
Response.End();
}
Thanks,
Komal
View 1 Replies
View Related
Jul 4, 2007
Hi
I'm trying to connect to the northwind database thats available online using c# and SQL 2005, both express editions. i used the following command
sqlcmd -S yourServerSQLExpress -E -iinstnwnd.sql
and it connects to the northwind database. but when it comes to the part where i have to select the data source, there are only 2 available - microsoft access database file, microsoft SQL server database file. but according to the microsoft books that i'm following, there should also be a "micosoft SQL server" in the data source list. because of this i cant connect to the database.
Please help...
thank you
View 3 Replies
View Related
May 27, 2008
I have everything enabled and I still can't connect to the server. Everytime I try to connect to MS SQL Express from home I get this error:
TITLE: Connect to Server
------------------------------
Cannot connect to 67.159.*.*SQLEXPRESS.
------------------------------
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 have Remote Connections enabled (I think). Any advise is greatly appreciated.
View 13 Replies
View Related
May 31, 2007
Hi!
I'm trying to connect a DB in SQL express with a program in VB.NET Express. I'm using the Data Source Configuration Wizzard. When I select the file (.mdf), the following message appears:
Unable to open the physical file "path to my file". Operating system error 5: "5(error not found)".
An attempt to attach an auto-named database for file 'myFile' failed. A database with the same name exists, or secified file cannot be opened, or it is located in UNC share.
I'm using the Windows authentication for this, but if I try with the sa user, I get the following message:
Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.
Any ideas to solve this?
Thanks
Jose Israel
View 1 Replies
View Related
Feb 20, 2006
1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHIDSQLEXPRESS".I wants a connection string with respect to this server.2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.I have installed sample databases but can't find script for pubs and northwind nor it install automatically.I wan't to use tutorial's sample.
View 1 Replies
View Related
Aug 8, 2006
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
View 11 Replies
View Related
Sep 30, 2007
pls i have asp.net page that i want to connect to sql server express edition database and i want data to be submited from the page into sql server express edition database that i have in my project folder when i click on submit button pls help me with the code to do this
View 1 Replies
View Related
May 9, 2006
I downloaded the SQL Server 2005 Express SP1 product today. If I right click SQLEXPR.EXE, select Properties, and select the Version tab, the File Version value is 0.0.0.0. The version listed for the GA product was 9.0.1399.6.
Is this a problem to be concerned about?
View 3 Replies
View Related
Dec 7, 2006
Hi,
I am currently using VC++/Cli 2005. In a project, I'm using a DataGridView control to show records from a SQL Express 2005 table. Instead of updating a specific item directly within DataGridView control, I would like to open a new form and allow user to update selected record/item within that form. The reason to update this way is conditionned by the fact that I have 3 levels of detail as following:
Level 0 Level 1 Level 2
1:N 1:N
Furniture --> Component --> Component
You all understand that update form of Level1 will/must include, as Level0 do, another DataGridView control to display/detail all related items issued from next level. This explains why I can't allow user to update Level 1 directly from DataGridView control.
I've searched in MSDN and even bought a few books on subject but unfortunately I found nothing on how to do it this way. All articles on DataGridView control were only showing how to update record directly from control.
My approach, I think, would be to transmit to my level1 updating form, as a single parameter, the selected DataRow object (or a brand new one if currently adding) issued from DataGridView and let user update it's content. When User finally leaves level0 update form, then I presume that DataGridView corresponding table would be automatically updated according to DataGridView's content.
What would be the proper way to do it? I would certainly appreciate to hear you view on this.
Also, what can I do if I want to refresh DataGridView's content when coming back from update form. Is it done automatically? I would certainly be sure that it reflects the reality, not only when I update it myself but also especially when other users could concurrently update same records?
Thanks in advance,
Stéphane
View 7 Replies
View Related
Oct 11, 2006
Sorry if this is going over old ground. I am trying to establish which version of SQL Express I have (Sounds daft I know!)
From Server Management app it tells me the following:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Is SP! appropriate, or am I there already?
Best regards (ever so 'umble!)
John
View 3 Replies
View Related
Oct 10, 2006
I created an ASP application using Web Developer Express and SQL Server Express on my workstation. Everything works great. I copied the application and all files to my intranet server which is a 2003 server running Sharepoint. When I attempt to run the application from the server.Access to the ADO.net Managed Provider 'SqlClientFactory' was denied in the data source with ID 'SqlDataSource' because of security settingsIs there something in the web config that I must change or settings on the server that must be changed for the application to run?
View 2 Replies
View Related
Apr 22, 2007
I'm an elementary C# developer.I find servers in local network using "SmoApplication.EnumAvailableSqlServers()" and fill a comboBox with them but I don't know how to distinguish SQLServers from SQLServer Express version.
Can you help me please that what can I do?
thanks a lot
View 2 Replies
View Related
Mar 9, 2008
I am not sure which one I downloaded. whether it was the one with or without "extra" analysis and reporting features.
View 5 Replies
View Related
Apr 16, 2007
When I downloaded/started using Visual Web Developer I was under the impression that I needed to install SQL Server Management Studio Express in order to create/manage databases, and to provide the engine to access the data.
Since then I have found tutorials and have successfully created/used databases solely from within Visual Web Developer. I'm assuming that Visual Web Developer includes a database engine, much like the webserver that is included. (This is an awesome thing).
When I tried to upload my web application with database to my production server, the database would not work, it started working after I installed SQL Server Management Studio Express on the server.
Is it my understanding that you need SQL Server Management Studio Express if you do not have Visual Web Developer Express installed in order to provide the data access engine?
Also, I am unable to "attach" my Visual Web Developer Express created database to SQL Server Management Studio Express. Are there any posts that provide more information about this topic?
The only reason I'm asking is that I have extra whitespace on the end of my text fields, and I thought ANSI_PADDING was turned on. I do not see the option in Visual Web Developer Express, but have found it in SQL Server Management Studio Express.
View 14 Replies
View Related
Aug 31, 2007
Hi all,
In my SQL Server Express (that is installed in my Windows XP Pro PC), SQL Server 2005 Network Configuration has Protocols for SQLEXPRESS. I tried to do "Enabling CLR Integration" in my SQL Server Express: (1) If I clicked on "Surface Area Configuration for Services and Connections", I got an error "An exception occurred in SMO while trying to manage a service, (Microsoft.SqlServer.Smo) Additional information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The operation could not be completed. (WinMgmt). (2) If I clicked on "Surface Area Configuration for Features, I got a different error "Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required computer has the required Windows Management Instrumentation components and then try again. (SQLSAC) Additional Information: An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo). Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The operation could not be completed. (WinMgmt). Please help and tell me how I should do to get "Enabling CLR Integration" in my SQL Server Express done and how I can create SQLCLR Project in VB 2005 Express.
Thanks in advance,
Scott Chang
View 6 Replies
View Related
Aug 22, 2007
Hi all,
I have SQL Server Express and VB 2005 Express installed in a Microsoft Windows XP Pro PC that is a terminal PC in our office Network. My Network Administrator has granted my terminal PC for Administrator Use. I tried to do the ADO.NET 2.0-VB 2005 programming in my terminal PC and I could not get a remote connection in the Window Form Application via Window Authorization. I do not know how to make this kind of remote connection in my Network. Please help and advise.
Thanks in advance,
Scott Chang
View 6 Replies
View Related
Mar 5, 2008
Hi all,
For the first time, I want to set up the configuration of my SQL Server Management Studio Express (SSMSE) to allow me in doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. The SSMSE and VB 2005 Express are in my Windows XP Pro PC that is part of our NT 4 LAN System in our office. I read the article "How to configure SQL Server 2005 to allow remotre connections" in http://support.microsoft.com/kb/914277/ about (i) "Enable remote connections for SQL Server 2005 Express", (ii) Enable the SQL Server Browser service", (iii) Create exception in Windows Firewall, and (iv) Create an exception for the SQL Server Browser service in Windows Firewall. I entered the SQL Server Surface Area Configuration and I could not decide what options I should take for doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. I have the following questions on the page of "Minimize SQL Server 2005 Surface Area":
(1) I saw "Configure Surface Area for localhost [change computer]". I clicked on [change computer] and I saw the
following: Select Computer
The Surface Area Configuration of this surface area of this computer or a remote computer.
Specify a computer to configure: O Local computer
O Remote computer
Should I choose the "Local computer" or the "Remote computer" option?
(2) Below the "Configure Surface Area for localhost [change computer]",
I clicked on "Surface Area Configuration for Service and Connections", Select a component and then configure its services and connections: |-| SQLEXPRESS
|-| Database Engine
Service
I picked => Remote Connection
On the right-hand side, there are: O Local connections only
O Local and remorte connections
O Using TCP/IP
O Using named pipes only
O Using both TCP/IP and named pipes
Should I choose O Local and remorte connections and O Using named pipes only?
Please help and tell me what options I should choose in (1) and (2).
Thanks in advance,
Scott Chang
View 10 Replies
View Related
Nov 13, 2006
Hi,When I attempt to add the membership functionality to a database created within VWD Express, by using the aspnet_regsql.exe application (connecting to ./SQLEXPRESS using Windows authentication), the database I've created within VWD Express doesn't appear within the list of accessible databases. I have the same problem when attempting to access the same database within Management Studio Express.Does this mean that databases created from within VWD Express don't use the same storage mechanism or paradigm as those already available within Management Studio Express? Or perhaps I need to somehow register the database using Management Studio Express? As a side note, I'm not sure if the "File/Open File" menu option within Management Studio Express holds the answer to my problems, but rather bizarrely, it crashes Management Studio Express when I select it.Apologies for the rambling - in essence my question is "How can I make databases created within VWD Express appear within aspnet_regsql.exe and/or Management Studio Express?"Many thanks,Jon
View 6 Replies
View Related
May 17, 2007
hii download free starter kit timetraker application( i downloaded both Visual web devaloper and sql server express from the Internet) when i tried to run it it is showing the following errorAn 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: Shared Memory Provider, error: 40
- Could not open a connection to SQL Server)plz give me the solution above error thanks in advance vittal
View 2 Replies
View Related
Apr 4, 2007
I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.
BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Apr 03 19:36:54 2007
(LAPTOP NAME HERE) : Unknown article Result.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Apr 03 19:36:56 2007
(As you can see, there is nothing in the file)
Any ideas what could be wrong?
Thanks
Pedro
View 6 Replies
View Related
Sep 8, 2007
Hi
I have VC++ express and MSSQL SMS express and have an application working nicely locally. The Data explorer and data connections part works really easily.
Now, I want to make the application available to my home network.
I mapped the drive where the database is and called it Z: so I could put my "release" on my other network PC and assumed it would find Z: if I mapped the shared network drive on that machine and called it Z:
But: I can't even add the mapped connection on the local machine, I get:
The file "Z:databasescalorie.mdf" is on a network path not supported for database files. An attempt to attach.....etc"
It works fine on the original F drive.......
Am I approaching this the wrong way. How should I distribute to network PCs?
thanks hopefully
David
View 5 Replies
View Related
Feb 20, 2007
I have uninstalled the SQL Server Express Edition that I have installed from the CDs that were given to me during a Chicago Conference when READY TO LAUNCH Visual Studio 2005, SQL SERVER 2005, and Biz Talk 2005.
Then I went to microsoft website: http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx and downloaded and installed the so called Microsoft SQL Server 2005 Express Edition and I got the messages Error that you read below. Then I Uninstalled Microsoft SQL Server 2005 Express Edition and went again to msdn website and downloaded Microsoft SQL Server 2005 Express Edition Advanced Services SP1 and installed it. I got again the same message as below.
MESSAGE:
1. First comes a window with the title: €śsetup.exe €“ Unable to Locate Component€?
And it displays a message:
This application has failed to start because MSTDCPRX.dll was not found.
Re-installing the application may fix this problem.
2. After I click the OK button of this window it comes another window with the title: €śMicrosoft SQL Server 2005 Server Setup€?
And it displays a message: Failed to load SqlSpars.dll
Does anybody can tell what is going on with the 3 times I tried to installed different SQL Server 2005 Express Edition and I get the same message?????
Thanks for your help and support when you have time to respond.
Sincerely,
TonyC
MORE INFORMATION ON THE:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles
1. C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_Core.txt
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 87
Aborting queue processing as nested installer has completed
Message pump returning: 87
2. C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_Core(Local).txt Running: InvokeSqlSetupDllAction at: 2007/1/20 1:22:8
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Unable to load setup helper module : 87
Message displayed to user
Failed to load SqlSpars.dll
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/1/20 1:22:17
Message pump returning: 87
3. C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_Datastore.xml
<
<S,<Scope Type="SetupStateScope" Id="">
<Property Id="machineName">B3-XP</Property>
<Property Id="logDirectory">C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG</Property>
<Property Id="logSummaryFilename">C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt</Property>
<Property Id="logSequenceNumber">1</Property>
<Property Id="primaryLogFiles">{ ["C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_.NET Framework 2.0.log"], ["C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_Support.log"], ["C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_Core.log"], ["C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt"], ["C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_B3-XP_Core(Local).log"] }</Property>
<Property Id="watsonFailedAction">InvokeSqlSetupDllAction</Property>
<Property Id="watsonFailedActionErrorCode">87</Property>
<Property Id="watsonFailedFunction">sqls::InvokeSqlSetupDllAction::perform</Property>
<Property Id="watsonFailedFunctionErrorCode">87</Property>
<Property Id="watsonSourceFileAndLineNo">setupsqlsetupactions.cpp@1709</Property>
<Property Id="watsonModuleAndVersion">setup.exe@2005.90.3042.0</Property>
<Property Id="watsonMsi">None</Property>
<Property Id="watsonMsiAndVersion">None</Property>
<Property Id="watsonSourceFile">setupsqlsetupactions.cpp</Property>
</<Scope>
View 9 Replies
View Related
Feb 18, 2008
Hi,
I am a newbie so i apologies beforehand for any mistakes i make on this forum.
Anyway, i created an asp.net website using the MS Visual Web developer tool. This has a couple of SQL SERVER databases within it.
I then latervinstalled the SQL SERVER management studio express in order to manage the SQL SERVER DBs that i had as part of my website but they do not appear within the management studio db list.
As this is the express version, is there anyway of importing the existing SQL SERVER dbs that i have to the management studio so i can manage them from there?
Regards,
Shuja.
View 5 Replies
View Related
Mar 21, 2007
As I said in the subject I've a problem trying to restore a backup of a previous db created in sql 2000 server
When I try to do it I recive the following message:
____________________________________________________________________________________
System.Data.SqlClient.SqlError: Il set di backup include il backup di un database diverso dal database 'musica2007' esistente. (Microsoft.SqlServer.Express.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
------------------------------
Program Location:
in Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
in Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
in Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
____________________________________________________________________________________
What should I do? What's the probem? I've already tried to look for the solution in other messages but I didn't find anything..... Thanks for help,,, by Luke
View 1 Replies
View Related
Mar 4, 2007
Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Sun Mar 04 15:25:13 2007
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error Number : 29513
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Sun Mar 04 15:27:03 2007
List of log files:
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Core(Patched).log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Datastore.xml
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_.NET Framework 2.0.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Support.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Core.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SCC.log
View 8 Replies
View Related
