Can Multiple Workstations Running SQL 2005 Server Express Attach To The Same Database Files On A Shared Network Location?
Can multiple instances of SQL 2005 Express attach to the same database files on a network share? I have seen this done before with MSDE where the database files are stored on the server, but instead of having a SQL server running on the network and then connecting to it, only the database files exist on the network share and the users connect through MSDE running on the local machine. Is this possible with SQL2005Express? I do not have the ability to share an SQL instance from one workstation to another nor do I have the ability to install an instance on the corporate server. Is it as simple as creating the database and storing the files on the share then attaching the database to the SQL Instance on each workstation?
View Complete Forum Thread with Replies
Related Forum Messages:
Attach Network Database Sql Server Express
I am trying to attach a network database to my sql server express After some reading I "Enabled" tcp/ip, named pipes, and shared memory in sql server confiuration manager. But when I go to "Attach Database" in Sql Express managemnent studio. It does not show the network drives much less allow me to attach anything on a network drive. What am I missing here? If I install sql server on the network machine will my local Sql express recognize it?
View Replies !
SQL SERVER EXPRESS BETA1 (2005) IS NOT RUNNING :SHARED MEMORY Provider Error
I'm facing several problems that I tryied to short out by msdn but could not get solution I'm using visual studio .NET 2005 Beta(WHIDBEY),and problem:1 sql server2005 Express edition is not running on My stand alone machine(AMD Athlon Xp 2000+,512 MB DDR Ram,CPU Clock speed 1.67 GHz) Whenever I try to connect to SqlExpress using the server explorer in the VisualStudio.NET 2005 using follwing option in connection properties Dialog Box : 1.server name: the name of my computer(I'm using the Default Instance of SQLEXPRESS 2005) 2.Enter Information to log on to the server:usewindowsNt Integrated Security3.when I go to select the inuilt data base like masters it gives following Error message:- "Shared memory provider:Specifed Module could not be Found" problem:2In the process of making of Data Access component,I made an assembly named "TNB.DataLayer.CSharp.dll" and putted it at two place one in the ..in folder and another in the folder having the solution file .Now I want this asssenbly to put in Global Assembly cache so that parts of my project (a window Application and a Web Application) can access the database using this TNB.DataLayer.CSharp.dll Now i need to make my assembly a strong name so I used following at the .NET command Prompt sn.exe -k TNBKeyPair.snkand put this file in the folder where My solotion .sln file exist.now as I have the keypair file,I tryied to sign the assembly TNB.DataLayer.CSharp.dll with this key for this when I added the following in to the AssemblyInfo.cs file[assembly: AssemblyKeyFileAttribute("TNBKeyPair.snk")] warning on bulding the solution is Warning 1: Use command line option '/keyfile' or appropriate project settings instead of 'AssemblyKeyFileAttribute' D:gopaldot net newTNBTNBPropertiesAssemblyInfo.cs 19 11 and when I use the /keyfile:TNBKeyfile at the command prompt I got another Error message:The file name, directory name, or volume lable syntax is incorrect. and finally I'm not able to sign the Dll and to put it in global assembly to use from different envioronments. so please help me in solving this problem. Thanks! ur faithfully
View Replies !
Attach Database Failed For SQL Server 2005 Express
I have installed a sample from the web and put it in my localhost inetpub folder, then i open up my SQL Server 2005 Express to attach the database from the App_Data directory, it throws an error below: errors occur in both window and sql authentication login. Error: Attach database failed for Server '...SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) Additional Information An exception occcured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) Directory lookup for the file "C:Documents and SettingsmirtariqMy DocumentsWorksStarterKitVSI smallbusiness_csApp_DataSmallCompanyDB_log.LDF" failed with the operating system error 3(The system cannot find the path specified.).(Microsoft SQL Server, Error:5133)
View Replies !
Attach Database Problem - SQL Server Express 2005.
I m facing a strange phenomenon. Please refer to below points. environment: ------------------ windows XP sp2 SQL Server 2005 express [log on as 'network service'(by default)] programming language: VC++(MFC) There is a sample database in .mdf format which to be attached to SQL Server. Ist case: ------------ I add MASTERDSN (for master databse) to ODBC by calling API SQLConfigDataSource() and then attach the sample DB to SQL Server by calling stored procedure 'sp_attach_db' through VC++ code. On verification from SQL Server management studio express, the DB attached is in read only mode. II case: ---------- I add MASTERDSN using ODBC data source administrator manually. Now I add MASTERDSN (again with same name) by calling API SQLConfigDataSource() and then attach the DB to SQL Server by calling stored procedure 'sp_attach_db' through VC++ code. Now on verification, the DB attached is not in read-only mode. The problem is that why there is difference in behavior in both cases? I want to get the sample DB attached in read-write mode in Ist case. Hopefully waiting for ur response. Thanks & Regards
View Replies !
Installing / Running Multiple Instances Of SQL Server Express 2005
My client has a server running MS 2003 Server for Smal Business Server, and it has SQL Server Express 2005 installed (I believe it is installed 3 times, as part of SharePoint, Veritas Backup Exec and ACT! applications). I am trying to implement an application that uses SQL Server 2000, but the Server 2003 SBS does not support that version. So I need to launch an additional instance of SQL Server Exp 2005. To do so, do I need to download and install SQL Server Express 2005 software again? Or can I just run SQLSVR.exe from an existing instance, but with a different instance name (sqlservr.exe -s<InstanceName>? The reason I need another instance is that these existing instances limit DDL statements. I am new to this and compare it to launching MS Word multiple times - you don't need to reinstall Word to run it multiple times. Is launching from the command line a bad idea - and if it is, what is the better way to ensure that it launches under the local system context a service? Thanks in advance for any help and insights. It is much appreciated.
View Replies !
Failed To Attach AdventureWorks_Data.mdf Into SQL Server 2005 Express Database In Local
After i reinstall SQL Server 2005 Express on my local machine, and then tried to attach AdventureWorks_Data.mdf into Database, it gives me the following error: Mark up: I tried to reinstall the Adventureworks.msi installer and reattach again in SQL Server 2005 Express, it gave me the same error. I then deleted both SQL Server 2005 Express & Adventureworks, and then restart my pc and reinstall again, it still gave me the same error. Error: Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) Additional Information: An Exception occurred while executing a Transact-SQL Statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL.1DataAdventureWorks_Data.mdf' (Microsoft SQL Server, Error:5123)
View Replies !
Can't Attach Database Both Sql 2000/2005 Express ?
Hi All I try to attach MobileShop_Data.MDF database by using SQL server 2000 and SQL 2005 Express, but It's impossible . I don't know why . Someone can help me bypass this problem ? this is my database . http://www.4shared.com/file/26729050/17b56825/Database.html Many thanks in advance . ... regards, Quachnguyen
View Replies !
Location Of Default Instance SQL Server 2005 Files
I have just installed SQL Server 2005. I was not given a choice during installation (that I remember seeing anyway) about which drive I wanted to place the default SQL instance on. It ended up on C: and I needed it on D:. So my questions are: Is there a way to move it to D: that is easier than the way you had to go about it in SQL 2000? Is there a way to do it during setup so I can avoid this in the future?
View Replies !
Considerations... Backing Up IIS 6 Web Files And SQL Server 2005 Express Database
Anyone know of a good "free" way to back up web files and SQL Server 2005 Express Database? I was able to use Windows Server 2003 Backup utility to back up the folder where the Databases were stored, as well as the web files, with no errors. But I have heard a lot of discussion that you can't just simply backup SQL Server data files? I'm wondering how sound the backup I've created is... Any suggestions?
View Replies !
SQL 2005 Clustering On A Shared Network Folder?
Hi, all, For a standard cluster, a shared storage is required. I am wondering if it is possible to have SQL 2005 cluster to be created on a network share folder, instead of the shared storage disk. For example, ServerS has a shared folder that can be accessed from both ServerA and ServerB. Can we use this shared folder to build a SQL 2005 cluster of ServerA and ServerB? Thanks.
View Replies !
Attach Database File Over The Network.
Hello, I have Sql Server in one pc and I want to attach one databse that is in another computer that doesnt have SQL Server. Sql Server doesnt permit UNC path when attaching database files. Is there anyway to workarounf this. Is Trace Flag 1807 of any use? Thanks
View Replies !
SQL Express-solving 4GB Size Limit By Multiple Database Files?
Hi,I am new to SQL express and try to solve the 4GB size limitation.Is there a possibility to create a new database file every time I getto the limit?How can I do that with C#? how can I create new database file everytime it gets full?Can I be connected to two database files at the same time (the full dband the new db)?thanks in advance,oren
View Replies !
How Do You Connect To SQL 2005 Express Database On Network Share
Hello, Ho do I allow multiple users to share a database? Background I have developed a Windows App in VS.NET 2005 which connects to a SQL 2005 Express database. Now I want to install the app and database on the network and I am getting an error "File 'file_name' is on a network device not supported for database files" What is the best way to get this working Thanks in advance, Phil
View Replies !
Problems Of Remote Connections For Creating A SQLCLR Project In SQL Server Express-ADO.NET 2.0-VB 2005 Express Via Network/LAN
Hi all, In my office computer network system (LAN), my Windows XP Pro PC has SQL Server Express and VB 2005 Express installed and I was granted to have the Administrator priviledge to access SQL Server Express. I tried to create a SQLCLR project in my terminal PC. 1) I tried to set up a remote connection to SQL Server Express in the following way: SQL Server EXpress => SQL Server Surface Area Configuration. In the Surface Area Configuration for Service and Connection - local, I clicked on Remote Connection of Database Engine, SQLEXPRESS and I had a "dot" on "Local and remote connections" and "Using TCP/IP only". Then I clicked on "Apply" and "OK" buttons. Then I went to restart my database engine in SQL Server Management. When I went to check SQL Server 2005 Surface Area Configuration, I saw the arrow is pointing to "Service", not to "Remote Connections"!!!??? Is it right/normal? Please comment on this matter and tell me how I can have "Remote Connecton" on after I selected it. 2) After I restarted the database engine (I guess!!), I executed the following project code (copied from a book) in my VB 2005 Express: //////////////--Form9.vb---///////////////// mports System.Data.SqlClient Imports System.Data Public Class Form9 Dim cnn1 As New SqlConnection Private Sub Form5_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 'Compute top-level project folder and use it as a prefix for 'the primary data file Dim int1 As Integer = InStr(My.Application.Info.DirectoryPath, "bin") Dim strPath As String = Microsoft.VisualBasic.Left(My.Application.Info.DirectoryPath, int1 - 1) Dim pdbfph As String = strPath & "northwnd.mdf" Dim cst As String = "Data Source=.sqlexpress;" & _ "Integrated Security=SSPI;" & _ "AttachDBFileName=" & pdbfph cnn1.ConnectionString = cst End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Create a command to create a table Dim cmd1 As New SqlCommand cmd1.CommandText = "CREATE TABLE FromExcel (" & _ "FirstName nvarchar(15), " & _ "LastName nvarchar(20), " & _ "PersonID int Not Null)" cmd1.Connection = cnn1 'Invoke the command Try cnn1.Open() cmd1.ExecuteNonQuery() MessageBox.Show("Command succeeded.", "Outcome", _ MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show(ex.Message) Finally cnn1.Close() End Try End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click 'Create a command to drop a table Dim cmd1 As New SqlCommand cmd1.CommandText = "DROP TABLE FromExcel" cmd1.Connection = cnn1 'Invoke the command Try cnn1.Open() cmd1.ExecuteNonQuery() MessageBox.Show("Command succeeded.", "Outcome", _ MessageBoxButtons.OK, MessageBoxIcon.Information) Catch ex As Exception MessageBox.Show(ex.Message) Finally cnn1.Close() End Try End Sub Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click 'Declare FromExcel Data Table and RowForExcel DataRow Dim FromExcel As New DataTable Dim RowForExcel As DataRow FromExcel.Columns.Add("FirstName", GetType(SqlTypes.SqlString)) FromExcel.Columns.Add("LastName", GetType(SqlTypes.SqlString)) FromExcel.Columns.Add("PersonID", GetType(SqlTypes.SqlInt32)) 'Create TextFieldParser for CSV file from spreadsheet Dim crd1 As Microsoft.VisualBasic.FileIO.TextFieldParser Dim strPath As String = _ Microsoft.VisualBasic.Left( _ My.Application.Info.DirectoryPath, _ InStr(My.Application.Info.DirectoryPath, "bin") - 1) crd1 = My.Computer.FileSystem.OpenTextFieldParser _ (My.Computer.FileSystem.CombinePath(strPath, "Book1.csv")) crd1.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited crd1.Delimiters = New String() {","} 'Loop through rows of CSV file and populate 'RowForExcel DataRow for adding to FromExcel 'Rows collection Dim currentRow As String() Do Until crd1.EndOfData Try currentRow = crd1.ReadFields() Dim currentField As String Dim int1 As Integer = 1 RowForExcel = FromExcel.NewRow For Each currentField In currentRow Select Case int1 Case 1 RowForExcel("FirstName") = currentField Case 2 RowForExcel("LastName") = currentField Case 3 RowForExcel("PersonID") = CInt(currentField) End Select int1 += 1 Next int1 = 1 FromExcel.Rows.Add(RowForExcel) RowForExcel = FromExcel.NewRow Catch ex As Microsoft.VisualBasic.FileIO.MalformedLineException MsgBox("Line " & ex.Message & _ "is not valid and will be skipped.") End Try Loop 'Invoke the WriteToServer method fo the sqc1 SqlBulkCopy 'object to populate FromExcel table in the database with 'the FromExcel DataTable in the project Try cnn1.Open() Using sqc1 As SqlBulkCopy = New SqlBulkCopy(cnn1) sqc1.DestinationTableName = "dbo.FromExcel" sqc1.WriteToServer(FromExcel) End Using Catch ex As Exception MessageBox.Show(ex.Message) Finally cnn1.Close() End Try 'Read the FromExcel table and display results in 'a message box Dim strQuery As String = "SELECT * " & _ "FROM dbo.FromExcel " Dim str1 As String = "" Dim cmd1 As New SqlCommand(strQuery, cnn1) cnn1.Open() Dim rdr1 As SqlDataReader rdr1 = cmd1.ExecuteReader() Try While rdr1.Read() str1 += rdr1.GetString(0) & ", " & _ rdr1.GetString(1) & ", " & _ rdr1.GetSqlInt32(2).ToString & ControlChars.CrLf End While Finally rdr1.Close() cnn1.Close() End Try MessageBox.Show(str1, "FromExcel") End Sub End Class ////////////////////////////////////////////////////////////////////////////// I got the following error messages: SecurityException was unhandled Request for the permission of type 'System. Security. Permissions.FileIOPermission,mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'failed that is pointing to the code statement "Dim int1 As Integer = InStr (My.Application.Info.DirectoryPath, "bin")." Troubleshooting tips: Store application data in isolated storage. When deploying an Office solution, check to make sure you have fulfilled all necessary requirments. Use a certificate to obtain the required permission(s). If an assembly implementing the custom security references other assemblies, add the referenced assemblies to the full trust assembly list. Get general help for the exception. I am a new Microsoft VS.NET Express user to do the SQL Server 2005 Express and VB 2005 Express programming by using the example of a tutorial book. Please help and tell me what is wrong in my SQLCLR sep-up and project coding and how to correct the problems. Many Thanks in advance, Scott Chang
View Replies !
Transferring Existing SSIS Packages Saved In A Shared Folder Location From Development Server To Live Server
Please can anybody help me in transferring existing SSIS Packages saved in a shared folder location from development server 2ED to Live server TWD1. Both has SQL server 2005 running and has visual studio 2005 Currently about 25 SSIS packages are executed from the development server transferring data on Live server TWD1...these ETL process is called from development server but executed on live server. Now the problem is when i call these packages from the shared folder from live server it crashes.....i need to changes something to shift the whole package to the live server..and execute on live server itself instead of recreating the whole 25 process from scratch.....also i use optimize for many tables ..and run in a single trancastion....so how can i see the mappings of source and destination tables. Please let me know the process how i can achieve this. Thanks George
View Replies !
Can't Attach Database Using SQL Server Management Studio Express
I am having a problem Attaching, well actually not being able to see a database when attempting to attach it. I suspect this is more of a security issue rather than a problem with Management Studio, but I can't figure out what is happening. If I copy a database to Documents and SettingsAll Users... and attempt to attach I can see the file in the selection tree. This also is the case if I copy it to Documents and SettingsDefault User... But if I copy it to Documents and SettingsADynarski... which is the account I normally log into, when I expand the folder in the selection tree, nothing is visible. And the same thing occurs if I copy the file to Documents and SettingsGuest... I've looked at the security settings and everything appears to be normal. This is on a box with XP Home and SQL Server Express. Can anyone tell me what I'm missing? Thanks, Al
View Replies !
How Can I Attach AdventureWorks Database To SQL Server Management Studio Express?
Hi all, I just downloaded AdventureWorks_Data.mdf, AdventureWorks_Data.ldf, AdventureWorksDW_Data.mdf, and AdventureWorksDW_Data.LDF files to the C:Program FilesMicrosoft SQL ServerMSSQL.1|MSSQLData folder of my Windows XP Pro PC. I tried to attach the AdventureWorks database in my SQL Server Management Studio Express in the following way: I clicked on SQL Server 2005 Express=>SQL Server Management Studio Express=>Right clicked on Databases=> clicked on "Attach..."=> "Attach Databese" showed up. But I can not type in anything under the MDF File Location, Database Name, Attach As, Owner, Status, Message!!!??? What is wrong in my way of doing the attachment of AdventureWorks database (described above)? Please help and advise. Thanks, Scott Chang P. S. I do not have Microsoft Visual Studio 2005. Walkthrough: Install the AdventureWorks Database (http://msdn2.microsoft/en-us/library/ms31035.aspx) : To confirm your SQL Server data directory (Start=>All Programs, Microsoft Visual Studio 2005, Visual Studio Tools, Visual Studio 2005 Command Prompt) steps 1 thru 4 can not be applied to my SQL Server Management Studio Express. I read an SQL Express post dated 19 April 2006 and learned the above-mentioned way to attach the AdventureWorks database in the SQL Server Management Studio Express. But that way does not work for me.
View Replies !
Can't Attach SQL Server 05 Database To Visual Studio 05 Project Because VS Is Asking For SQL Express Components
We recently started the process of upgrading our development platform to Visual Studio 2005 and SQL Server 2005 on our servers and SQL Devloper 2005 on our desktops. Yesterday I attempted to attach a SQL database I built to a test website project I have been building in VS. When I clicked the button to create the connection, I got this.... "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251" even though I can clearly see the reference to my database in the server explorer tab in VS. I initially installed the Express version that came with Visual Studio, but uninstalled it after I kept getting errors saying I couldn't create remote connections, even when I was only trying to connect to an instance I set up on my local workstation. I went back to SQL Server Developer 2005, because it worked in the past, and I was able to create and connect to my databases in my other projects. Can someone tell me what is causing this issue? It's become a showstopper, because I can't finish my project, and I'm not thrilled with the idea of my developers having this problem when we roll Visual Studio out. Thanks in advance....
View Replies !
Linked Server For Mdb File On A Shared Network Drive
Hi I am having an Access database on a shared network drive which has read/write access rights on the that shared network drive. When I try to Access data through the linked server it gives me gives me a message box saying you do not have permissions to view the data. Also if i try to use xp_cmdshell to copy over the mdb file to my local drive it say 'Access denied' But when I copy (through command prompt) the same file to another network drive or my local drive where I have full control the linked server can connect sucessfully. The problem is the i cannot have 'full control' permissions on shared drive where my database resides. Has anybody encountered this problem.... Any help will be greatly appreciated. Urgent Puru
View Replies !
How Do I Upload To And Download From A Shared SQL Server 2005 Database?
My hosting gives me ASP.NET 2.0 and a shared SQL Server 2005 package. I have Visual Studio 2005 on my machine - which installs SQL Server 2005 Express. I have also installed SQL Server 2005 Management Studio Express. I wish to develop my database locally (mdf file) as I won't always have internet access (and therefore can't always work directly with the remote shared database). My question is, how do I upload my database info from my local machine to my remote shared database? Also I shall wish to download my remote database to my local machine in order to work on the database (and then be able to re-upload it) sometimes. Please can somebody tell me how I can do this? Will SQL Server 2005 Management Studio Express permit me to do this and if so how? If I need the full version of SQL Server 2005 Management Studio then I do have SQL Server 2005 and this install with it (but it all looks a bit complicated to install for me). Many thanks for all help given, Graham
View Replies !
Sql Server 2005 Express And Network Connection
We have a native Visual C++ application compiled with VS 2005 that when it starts establishes a connection to a local (on the same computer) sql server 2005 express database through ADO with OLEDB provider for sql server, and keeps the connection opened during all its life. The computer could have any network connection for example a local network hence have a network adapter or an ADSL modem. When the application starts with the network connection active, any operation on the sql server connection fail after whether the network connection has been closed, for example disabling the network adapter or the ADSL modem. The first error I get is: description literally translate from italian "generic network error" in english may be "Communication Link Failure" SQL State: 08501 Native Error: 11 That doesn't happen whether the application start while the network connection is not active that is whether the sql server connection is established while the network connection is not active. That is whether network connection is not active I start my application and then enable and disable the network connection over and over and the application always works fine. I have noticed that when the sql server connection is opened while the netwok connection is closed the columns values of client_net_address and local_net_address in the sys.dm_exec_connections table are the localhost ip address 127.0.0.1 whereas if the sql server connection is opened while the netwok connection is opened that values are equal to the network adapter ones (ex 10.0.0.106). In the string connection we use "local" or "computer name" for server value. May be I have to use "localhost" instead of "local" in the sql connection string?
View Replies !
SQL Server Express: Restore, Backup And Attach Do Not Work Anymore && Database Locations Fault
Hello there, I've some really big problems with SQL Server 2005 Express. I Recently, I had 2 instances on my machine, one was a SQL Server 2000 Developer and the other a 2005 Express Version. The 2000 version was not necessary anymore, so I unstalled it, since then, the Express version keeps having probems. Under the Server Properties -> Database settings -> Database Locations I've changed the path to D:sqldatamssql, but now, the programm always takes the "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" to store and load the databases, no matter what I do. And there are more problems see here: Restoring does not work======================= I wanted to restore a database called "fw40_admin" from a backup file (.bak), but that didn't work at all, it always says this as an error: "System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'D:sqldatamssqlfw40_admin.mdf'. (Microsoft.SqlServer.Express.Smo)" But as soon as I type in the installation path "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" inside the "Restore As" under "Options", it works. Why does the backup only work in "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData", BUT the database locations under the server properties is indicated with "D:sqldatamssql"???? Attaching does not work======================= Attaching an existing database does not work either. Most databases (mdf) are located on the path D:sqldatamssql, but as soon as I press Attach Databases -> Add The dialog window appears with the "D:sqldatamssql" path, but it is unable to find any *.mdfs altough THERE ARE .mdfs in this directory. But Express can find databases in the selected installation: "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData". Why can't Express see the directory on the D: partition??? What is wrong? Here? Can anybody help me?
View Replies !
SQL Server 2005 Default Database Location
Hi, I would like to change the default location where new databases are created. In Server Management Studio, I right clicked my instance and selected Properties. I selected the Database Settings option and am presented with an option to change the Database Default Location (the location for databases and logs can be changed here). If I change the paths for the DB's and logs, and create a new DB, the new files are saved to the new default location paths that I just entered. My question is this: If I change these paths, will my system databases (master, model, msdb, tempdb) still be accessible and usable by SQL server? I don't need (want) to change the location of these files, only all my other databases and logs. Will this do what I want? Thanks for the help! Oliver
View Replies !
SQL Server Management Studio Express: Object Explorer - How To Re-attach The Content Of User-defined Database
Hi all, I just found that the content of my Database "ssmsExpressDB" is gone, but the name "ssmsExpressDB" remains in the Object Explorer of SQL Server Management Studio Express. If I delected the name "ssmsExpressDB" and executed the following .sql: exec sp_attach_db @dbname = N'ssmsExpressDB', @filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf', @filename2 = N'C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB_log.LDF' GO I got the following error message: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". And I have closed all my projects and I do not know what " The process cannot access the file because it is being used by another process" is all about!? Please help and tell me how I can re-attach the content of my "ssmsExpressDB" in the Object Explorer of SQL Server Management Studio Express. Thanks in advance, Scott Chang ==================================================================================== I found the "ssmsExpressDB" is being used by my VB 2005 Express project "Hello-SQLCLR-1": in the Database Explorer, Data Connections place. How can I put it back to the Object Explorer of SQL Server Management Studio Express? Please help and advise. =======================================================
View Replies !
SQL Server Management Studio Express: Object Explorer - How To Re-attach The Content Of User-defined Database
Hi all, I just found that the content of my Database "ssmsExpressDB" is gone, but the name "ssmsExpressDB" remains in the Object Explorer of SQL Server Management Studio Express. If I delected the name "ssmsExpressDB" and executed the following .sql: exec sp_attach_db @dbname = N'ssmsExpressDB', @filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf', @filename2 = N'C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB_log.LDF' GO I got the following error message: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". And I have closed all my projects and I do not know what " The process cannot access the file because it is being used by another process" is all about!? Please help and tell me how I can re-attach the content of my "ssmsExpressDB" in the Object Explorer of SQL Server Management Studio Express. Thanks in advance, Scott Chang ==================================================================================== I found the "ssmsExpressDB" is being used by my VB 2005 Express project "Hello-SQLCLR-1": in the Database Explorer, Data Connections place. How can I put it back to the Object Explorer of SQL Server Management Studio Express? Please help and advise. =====================================================================================
View Replies !
MS SQL Server 2005 -- Cant Not Attach To AdventureWorks Database
I have MS SQL Server 2005 installed and when trying to connect to AdventureWorks DB Downloaded AdventureWorksDB.msi file and when trying to attach recieve this error when running script ? Msg 1813, Level 16, State 2, Line 1 Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. Msg 602, Level 21, State 50, Line 1 Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Then tried to attach the DB and get this TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'JKIMBLE1'. (Microsoft.SqlServer.Smo) ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Is there a difference between MS SQL Server 2005 and SQL Server 2005 Express Edition
View Replies !
Configuration Of SQL SERVER 2005 Express Train For The Accesses Network (TCP/IP)
Hello. I am called Narsiste. I have a problem of configuration in SQL server 2005 express train. In fact, I do not know how to make the configuration to tackle the databases SQL server 2005 express train which are on a station has starting from a station B (both being in a network LAN). But I read in the module of €œconfiguration of the surface of exposure for the services and connections - localhost€? that €œBy defect, the editions Express train, Evaluation and Developer SQL SERVER 2005 authorize only local connections.€?. As it is BY DEFECT, I said myself that it will have to be changed a parameter so that access TCP/IP can go on this version of SQL SERVER. Here is the message which I have: €œAn error occurred during the establishment of a connection to the waiter. At the time of connection to SQL Server 2005, this failure can be due to the fact that the default settings of SQL Server do not authorize remote connections. (Provider: Interfaces network SQL, error: 26 - Error during the localization of the waiter/the authority specified) (Microsoft SQL Server, Error: -1)€?. If somebody encountered this problem in the past, that he wants to inform well me of the solution which he found for this last. Thank you.
View Replies !
Running Multiple SQL Query Files
I have several SQL files that make several different table updates and data changes. How would I create something (maybe an SSIS package?) or even write a T-SQL script that runs through these files and executes the queries contained in them? (I put this thread in SQL General also because I wasnt sure if this could be implemented in T-SQL or not.) Right now what I have is a ForEachLoop Container with an ExecuteSQL task component inside of it. I'm thinking that the contents of each of the sql files would be copied over to a "Temp.sql" file and then executed in the loop. So I've created a Temp.sql file for this purpose and the properties of the ExecuteSQLTask component are setup as so: (I've created my connection managers appropriately with an OLEDB source and a File Connection pointing to Temp.SQL) ConnectionType OLEDB Connection servertest SQLSourceType File connection FileConnection Temp.sql And for my ForEachLoop container, my properties have been set as: Collection --> Enumerator Foreach File Enumerator --- Enumerator Configurations --- Folder: C:lahblahblah Files: *.sql with retrieve file name set as Fully Qualified Have I set this up properly? (obviously not, because it's not working )
View Replies !
Unable To Attach DataBase In SQL Server 2005 Standard
Now that everyone helped me install SQL Server, it's time to use it... then... I'm trying to work my through the MS Press book ADO.Net Step by Step. After installing the practice files, there is a step to attach the sample database provided. Within the folder which contains the sample files, I'm told to execute an app which I believe was called "Config.exe". This app brings up a form with 3 text-boxes, to collect the Server Name, Database Name, as well as the Database MDF Filename. There are also 2 buttons, "Attach" and "Detach". This book assumes, that SQL Server Express is installed. In the book, the author does mention that if this isn't the case, to adjust the Server Name as necessary. (The following do not include the quotes, but you probably already knew that...) In the form mentioned above, the default Server Name is "(local)SQLEXPRESS", I changed this to "(local)MSSQLSERVER". The next text-box for Database Name contains: "AdoStepbyStep" The last text-box for Database MDF Filename contains: "c:ADO.NET 2.0 SBSSampleDBsAdoStepbyStep_Data.MDF" The path/spelling of the text in the above is indeed correct. Clicking the "Attach" button, results in the following: --- ERROR --- Function: AttachDB Description: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]InvalidConnection. [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (ParseConnectParams()). I've never used SQL Server, so please any advice needs to be at a relatively elementary level. I've primarily been a mainframe programmer, so this is new to me. Thanxxxxxxxxxxxxx in advance for any replies!!!
View Replies !
Running Multiple Version Of SQL Server On SQL 2005 ?
During customer engagement, I was told that there are Microsoft add-on to be installed on SQL 2005 and the SQL 2005 can be simulated as SQL 2000, SQL 2000 SP4, SQL 7.0 in different SQL instances. Is this true? Are there URLs about this topic? Thanks a lot. Po-Shan.
View Replies !
Trying To Attach Database In VS2005 And All DB Files Say They Are Being Used And To Close...they Are NOT Open.
Just to verify that this was an issue, I downloaded web developer 2008 and I do not experience this same problem. BUT when I go to add a dataset in vs2005 for an asp website - all my db files come up in the dialogue box but everyone that click (every db file) I get "This file is in use. Please enter a new name or close the file that's open in another program." But, like I said, I downloaded 2008 and it does not occur. Plus I KNOW that the db's are not being used. Can someone give me a remedy to this?
View Replies !
ODBC Connection For Client Application To SQL Server 2005 Express Installed On Network Computer
Hi All, I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine. I would now like to install my application on another workstation and connect remotely to the database located on my development machine. The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver? Thanks!
View Replies !
Maintenance Plan Fails Trying To Delete Files Older Thean One Day. Running SQL Server 2005
I get the following message when I execute a mantenance plan to delete files older than 1 day. Error # -1073548784 Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'',N'',N'2007-09-30T07:56:09' " failed with the following error: "Error executing extended stored procedure: Invalid Parameter". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Any help would be appreciated!!
View Replies !
Ho Do I Allow Multiple Users To Share A SQL 2005 Express Database?
Hello, Ho do I allow multiple users to share a database? Background I have developed a Windows App in VS.NET 2005 which connects to a SQL 2005 Express database. Now I want to install the app and database on the network and I am getting an error "File 'file_name' is on a network device not supported for database files" What is the best way to get this working Thanks in advance, Phil
View Replies !
Migrating From Sql2000 MSDE Database To Sql2005 Express - Attach Database Errors
I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached. Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error: Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them. But I should still be able to switch over to sql 2005?!?!?!? Or... is there a way to attach the databases to SQLExpress manually? Help pls?
View Replies !
SSIS Package Unable To Read File From Shared Location.
We are trying to import data from a .csv file which sits on shared location. This package runs fine when we run it from designer. but we are having problem when we do it at run time (accessing it through a service). Same package runs fine if that file is on same server. Is any one gone through this issue before? i appreciate any help in resolving this issue. --------Log---- #Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message OnPreValidate,SMSPAD1125M,RFCGKommar1,GIRI_ETL_XREF,{4D456D56-B35F-4FCC-8A89-2D03AC545C76},{5395DAA0-DB96-49CA-BDE7-0DA5C623A2B0},7/17/2006 10:46:42 AM,7/17/2006 10:46:42 AM,0,0x,(null) OnError,SMSPAD1125M,RFCGKommar1,GIRI_ETL_XREF,{4D456D56-B35F-4FCC-8A89-2D03AC545C76},{5395DAA0-DB96-49CA-BDE7-0DA5C623A2B0},7/17/2006 10:46:42 AM,7/17/2006 10:46:42 AM,-1073659875,0x,Connection "FlatFile" failed validation. --------------------------------- Thanks, -G
View Replies !
Database Connection: Mapped Network Drive (VC++ Express, MSSQL SMS Express, XP)
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 Replies !
Problem Running Sql Server 2005 Express On Vista
I have been trying to get Sql Server 2005 Express Advanced with SP2 installed and operating on my Vista machine. It seems to install ok but when I open Management Studio Express and try to create a new db or attach an existing one, I get error messages. So although it seems to be installed, I can't really use it.When I try to create a new database I get: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Create failed for Database 'practice'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ When I try to attach an existing database I get: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ The server principal "Dave-PCDave" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ I have tried following the links in the error messages but the result is: "We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere."I am successfully using both programs on my XP SP2 machines, so I know how to install and run them on XP, just not on Vista (yet). Any suggestions on how to proceed?
View Replies !
Attach Db To Sql 2005 Express Edition
My dog ate my sql2000 installation disk! After a recent xp installation I remembered that. Now I'm in a hurry to get up and running with SQL again. I've installed SQL server 2005 express, but I can't attach any databases, or really do anything for that matter. I have a copy of SQL Server 2005 enterprise edition but that won't install on my development machine, Xp Sp2. Which way should I go, install SQL 2005 enterprise on a Win 2003 server or can I download something to administer the express version? As always thanks for any and all replies! /Eskil
View Replies !
Getting Up And Running With Visual SQL Server 2005 Express And Visual Web Developer 2005 Express
I've downloaded and installed both of these (VWD installs both) and have been trying to run through the walkthrough of setting up a web application which supports membership. However, no matter what I do I invariably get errors like 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) I'm concerned why VWD and VSQL express versions don't run correctly out of the box (so to speak). I'm not an expert on configuring these services -- but that's the point of offering these tools to hobbyists: So we can learn about how to make some of these great applications using MS tools. My configuration:: Windows XP SP2 -- clean machine as of about a month ago, never had any dev tools, web servers, or the like on it. IIS is installed and the service says its running VSQL and VWD express versions installed (no errors on installation) SQL server service indicates it is running .Net 2.0 framework installed (no errors on installation) Note: I've tried installing on two separate machines. Obviously I'm missing something fundamental. Would someone please help me go through the million things I [apparently] need to do to configure all these tools so I can get on to actually coding up my first web application? If this is documented somewhere, all I can say is I tried to find it but it certainly wasn't obvious.
View Replies !
Unable To Attach SQL Express Database
Hello, I have a SQL Express database created with VWD 2005 and I want to attach it to the server using the SQL Server Management Studio. It is not the first time when I attach a database, but now, I don't know from what reason, it is not working anymore. So, I copy/paste the mdf and ldf files from the website location (the SQL Server Management Studio is not opening the folder C:usersmyuser in Vista Home Premium, don't know why) to a new location and try to attach. The error message is: TITLE: Microsoft SQL Server Management Studio Express------------------------------ Attach database failed for Server 'GEORGE-PCSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Unable to open the physical file "E:SQLaria.mdf". Operating system error 5: "5(error not found)". (Microsoft SQL Server, Error: 5120) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476 ------------------------------BUTTONS: OK------------------------------ The file location is OK, what can I do? Thanks.
View Replies !
MDF Files With VS 2005 Installed SQL Server Express
I created a mdf file but couldnt for the life of me install it into SQL Sever Express [and when I say install i mean attach]. When I used SQL Server Ent, I had no issues. The only warning I got was that my mdf file was used by another process when I tried to attach with VS 2005 [ which is correct because ent had it]. I think mdf files are pretty touchy. Does anyone have any good articles on best practices? It seems you cant have a db with the same name as your attachment [ which would make sense] or have mdf files in the Data directory of your SQL Server instance you are trying to attach to. You will get the unc share error if you do. I think I need to start using user Instances but I could be wrong. You cant use them in ent but maybe i will solve my issue with attaching db files to express. I noticed that by default express doesnt install in mix auth mode and there might be some issues with access. How does everyone else normally install their mdf files for quick deployment [ say you want to deploy your db with your app so that users can quickly get started] ?
View Replies !
|
TRACKER
