Connecting To MDF File Over Workgroup

Aug 16, 2006

Hi

I've build a client management (Windows) application in VS2005 which works fine on the local development machine but falls over when trying to connect to the SQL Server Express file located on a second machine on the same Workgroup. Several of the apllications will connect to the database file from networked computers.

The error I get when testing the connection or trying to connect via the App is:

---------------------------------------------------------------
The file "Z:BushBreaks.MDF" is on a network path that is not supported for database files.
An attempt to attach and auto-named database for file z:ushbreaks.mdf failed. A database with the same name exists, or specified file cannot be opened or it is on a UNC share.
---------------------------------------------------------------

How can I configure this database and/or connection to be able to allow connections to the MDF file? Please note that security is not an issue if that is at all relevant.

Many Thanks
John

View 1 Replies


ADVERTISEMENT

Will FTP And File System Tasks Run In Workgroup Edition?

Feb 1, 2007

I have a package that does an FTP and some File System Tasks. It runs perfectly fine in BIDS but doesn't want to run via SQL Agent. Is the SQL Server Edition the problem?

View 8 Replies View Related

Cannot Start Your Application. The Workgroup Information File Is Missing Or Opened Exclusively By Another User.

Aug 24, 2007

hye everyone,
when i browse my web application the eror as below display..
what should i do..
any suggestion or tips...

"Cannot start your application. The workgroup information file is missing or opened exclusively by another user. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. "


thanks in advance..
thank you very much..

View 1 Replies View Related

Error: Cannot Start Your Application. The Workgroup Information File Is Missing Or Opened Exclusively By Another User.

May 7, 2008

Hi all,
I'm kinda new at programming, and am currently attempting to create a web application.  I have an error when I try to insert information into a sql server database, and can't find how to fix it no matter how hard I try.
The error I get is: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
I have it so a user is logged in and is shown a form to fill out, then submits it (which creates an insert statement and sends it to the database).
My connection string is as follows:
CnnString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "data source=serverdestination;" + "User id=user;" + "Password=pass;";
If you need any more information, just let me know.
Any help would be greatly appreciated!

View 2 Replies View Related

Connecting Mdb File To A Calendar

Feb 21, 2008

Hi Everyone.
 I’m trying to read data from a databasefile called database.mdf which has a connection string called “ConnectionString1â€?. The aim is to highlit specific days in my calender. For example if there is an event in my database that day on the calander will be highlited. The database has  a columb called “Dateâ€? in a table called “Datesâ€?. Please can you help? My knowlade in asp.net and VB is very limited. This is as far as I have gone. (I don’t realy understand the VB part as I have copyed it from somone) I just need the vb code to connect to the database.
 
Imports System.Data.SqlClientImports System.DataImports System.Data.OleDb
Partial Class _Default    Inherits System.Web.UI.Page    Protected Sub Calendar1_DayRender(ByVal sender As Object, ByVal e As DayRenderEventArgs)        If IsExistMeeting(e.Day.Date.ToString("MM/dd/yyyy")) Then            e.Cell.BackColor = System.Drawing.Color.Red            e.Cell.ForeColor = System.Drawing.Color.Yellow        End If
    End Sub
    Function IsExistMeeting(ByVal datestring As String) As Boolean        Dim constr As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString1").ConnectionString.ToString() '"your connection string"        Dim connection As SqlConnection = New SqlConnection(constr)        Dim sqlsel As String = "select count(*) from Dates where CONVERT(char, date, 101)='" + datestring + "'"        Dim sda As SqlDataAdapter = New SqlDataAdapter(sqlsel, connection)        Dim ds As DataSet = New DataSet()        sda.Fill(ds, "Dates")        If ds.Tables("Dates").Rows.Count = 0 Then            Return False        End If        Return True    End FunctionEnd Class

View 2 Replies View Related

Locally Connecting To An SQL File

Feb 6, 2008

I am trying to loaclly connect to an sql file, i have installed SQl server management studio express, and have downloaded the file, so that i can access it locally, i have trawled about the whole of this site, but can't seem to find anything that helps.
The problem i have is i have a couple of guys telling me that i need to download the backup of teh database, which is in a .BAK format, then rename to .sql, and the open using sql 2005. However when i do this sql 2005 opens, but the a copy of notepad open infront of this, and the .sql file opens up in that. I am a total noob when it come to SQL however, with the help of some online tutorials have managed to teach myself SQL code, and a bit of basic PHP, but nowhere does it go into any great detail about the software surrounding SQl, or accessing the database, all the information i could find is on the code.

Any help would be greatly appreciated as my employers are getting a little bit anxious about all of this now, i know that once these creases are ironed out then i don't have a problem, but getting to the point that i am competent at is the trouble.

View 10 Replies View Related

Connecting To MSDE W/read Only File?

Jul 23, 2005

Hi,Does anyone know how I can connect to an MSDE db using VB with aread-only file? The file will be on a CD, and is actually just archiveddata off a SQL server. I would like to package my app on a CD alongwith the data file and allow users to pop in the CD and run the app,assuming they already have MSDE running. Any help?Thanks,Jason

View 1 Replies View Related

Problems Connecting To Sql Express 2005 Server, Where Mdf File Go?

Jul 10, 2006

Hello, I have correctly installed sql express 2005 onto my company server. I can connect to the sql express 2005 fine within sql management studio express. I can also connect to it the within visual studio 2005 server explorer. I have my database (MDF) on our server. I am trying to run my application within my client computer. I have changed the connection string property to connect to the server:

"Data Source=CTSSQLEXPRESS;Initial Catalog=UpdateAttributes;Integrated Security=True"

My program will only work if there is a local copy of MDF database located within my application directory. If I remove the local copy, it errors "No process is on the other end of the pipe" Is it possible to have my application without the local copy of the MDF? I thought the idea is to have the MDF on the server. Then my app would not have the MDF copy!?

View 1 Replies View Related

Connecting Database Engine (SQl Server 2005 File .*mdf) From Win CE 5.0 Platform

Jun 26, 2006

Is this possible to connect do the Database Engine (on sql server 2005 on XP platorm - file *.mdf (not mobile *.sdf)) from win CE 5.0?

I tried to do this :
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS;Initial Catalog=dbMachines;Integrated Security=False;Password=Panel;User ID=Panel";

SqlCeConnectionCE = new SqlConnection(ConnectionStringSQLServerCE);

SqlCeConnectionCE.Open();

but I catch error:
catch (PlatformNotSupportedException ex)
€žPlatformNotSupportedException€?
I noticed that I see server because when I use:
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS";

zwraca błąd typu

catch (SqlException ex)
€œLogin failed for user ''. The user is not associated with a trusted SQL Server connection.€?

I used
using System.Data.SqlClient;

from Compact Framework 2.0 under Visual Studio 2005 Device Application Windows CE 5.0

can anyone help me?

View 1 Replies View Related

Connecting To SQL Express 2005 Via Web.Config File In Visual Studio 2003

Oct 30, 2007

Hi
 I am following a project to build a small E-Commerce site from a book I have purchased and I have having problems connecting to the SQL Database with the code supplied.
The book is Apress Beginning ASP.NET 1.1 E-Commerce
http://www.amazon.co.uk/Beginning-ASP-Net-1-1-E-Commerce-Professional/dp/1590592549/ref=sr_11_1/202-7684451-7995058?ie=UTF8&qid=1193780707&sr=11-1
 The code added to the Web.Config file is :
<configuration>
<appSettings>
<add key="ConnectionString" value="Server=(local)NetSDK;Integrated Security=True;Initial Catalog=JokePoint" />
</appSettings>
 
The connection details are in a class file called Catalog.vb and is as follows
Imports System.Data.SqlClientPublic Class Catalog
Public Shared Function GetDepartments() As SqlDataReader
'Create the connection objectDim connection As New SqlConnection(connectionString)
'Create and initialize the command objectDim command As New SqlCommand("GetDepartments", connection)
command.CommandType = CommandType.StoredProcedure
'Open the connection
connection.Open()
'Return a SqlDataReader to the calling functionReturn command.ExecuteReader(CommandBehavior.CloseConnection)
End Function
Private Shared ReadOnly Property connectionString() As String
GetReturn ConfigurationSettings.AppSettings("ConnectionString")
End GetEnd Property
End Class
 The error is.....
Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'.Source Error:




Line 15: 'Open the connection
Line 16:
Line 17: connection.Open()
Line 18:
Line 19: 'Return a SqlDataReader to the calling function
Source File: C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb    Line: 17 Stack Trace:




[SqlException: Cannot open database "JokePoint" requested by the login. The login failed.
Login failed for user 'MachineNameASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
JokePoint.Catalog.GetDepartments() in C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb:17
JokePoint.DepartmentsList.Page_Load(Object sender, EventArgs e) in C:MyCommerceSiteJokePointUserControlsDepartmentsList.ascx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

The connection tests ok in Visual Studio 2003. All permissions are set using SQL Management Studio Express 2005.
The book is using SQL 2000, I have been trying different connection syntax's in the Web.Config file all day and now I have a big headache. I know its something simple, can anyone please advise ?
Thanks in advance.
 
Mark

View 3 Replies View Related

HELP: How To Avoid Ridiculous System Resource Issues When Connecting To A Huge Excel File

Sep 20, 2007

Hi all,

I have a 400MB Excel file that I consume from another automated process (don't ask). I copy this file down locally to my server, and I am attempting to create an SSIS package that points to this file via a connection manager. My computer starts gobbling up massive amounts of memory (devenv.exe gets up to about 800MB or so, then drops back down to 100MB) even when I attempt to rename the connection in the connection managers tab.

I have set all BypassPrepare to TRUE and ValidateExternalMetadata properties to FALSE, and still it can take up to 3 to 6 minutes for BI Dev Studio to respond. My specs:

Intel Centrino Duo 2.00 GHz
2GB RAM
XP Pro SP2

There MUST be a way for me to work effectively on a file of this size. Please help! Thanks much for any assistance.

Sincerely,

Brian Pulliam

View 4 Replies View Related

How To Set Access Workgroup

Jan 20, 2006

My package is to copy data from an Access 97 db into a SQL2k5 table.

Problem is that the 'mdb' is subscribed to a 'mdw' workgroup and I have been unable to workout / read how to get the SSIS manager to join the workgroup. Connection fails because "...you don't have necessary permission..."

I was able to do this previously for SQL 2k by messing with the registry, but I'm now on unfamiliar teritory.

Any answers? Cheers.

View 2 Replies View Related

Workgroup Upgrade

Jul 6, 2007

Has anyone had problems like this.
I recently got SQL Server 2005 Workgroup edition. I did the normal
'read everything I could' to make sure I was getting the correct version for my business.
After having to wait 4 weeks to upgrade, as we were waiting for our accounting system to be upgraded to come inline with SQL 2005, I came across the problem where DTS is not really compatible to the degree I needed with this edition.
I have since gone back to the reseller and they say we can't exchange it for Standard edition as 4 weeks has passed.
The only thing we can do is pay out (1 month later) another £6,000 to get the version we need, totaling £11,000
Being that we are a small business, paying out another £6,000 isn't an option.
Does anyone have any good advise on this?
Many thanks
Scott

View 4 Replies View Related

Domain Vs. Workgroup

Jan 31, 2008

My company has a large-ish website and we are migrating to new
servers. There will be a web server (accessible to the world) backed
by a SQL Server 2005 Standard server (only accessible by the web server and
through VPN/Remote Desktop to administrators and our internal
network). We can either put the database server (which is not in a
cluster) on our domain or leave it in a workgroup. My first thought
is leave it in a workgroup simply for security and reliability (i.e.
if the DC goes down or loses connectivity), but people here are
disagreeing with me.

Should I put the database server (which is not used internally at all)
on the domain or leave it in a workgroup?

View 1 Replies View Related

Domain Vs. Workgroup

Jan 31, 2008

My company has a large-ish website and we are migrating to new
servers. There will be a web server (accessible to the world) backed
by a SQL Server 2005 Standard server (only accessible by the web server and
through VPN/Remote Desktop to administrators and our internal
network). We can either put the database server (which is not in a
cluster) on our domain or leave it in a workgroup. My first thought
is leave it in a workgroup simply for security and reliability (i.e.
if the DC goes down or loses connectivity), but people here are
disagreeing with me.

Should I put the database server (which is not used internally at all)
on the domain or leave it in a workgroup?

View 1 Replies View Related

Cluster On Workgroup And Then Domain

Sep 26, 2005

We have a set of client servers which will include a SQL Server 2000 active/passive cluster attached to a SAN. We have all the equipment here (no attachment to client site) to configure. My worry is since it will have to be setup as a workgroup, and then shipped to client to add to their domain, is this a doable option. has anyone had to do this or tried this? Or would we be better off shipping whole thing to client and setting up cluster there?

View 6 Replies View Related

Copying Files Over Workgroup

Apr 8, 2004

I want to copy the database backup files to another server as a part of logshipping implementation. tried using xcopy it doesn't work.
it says "invalid drive specification"
also tried using a dll, the dll does the copying i just had to call the dll through an sp, while trying this the QA hanged, tried killing the process but the process didn't kill, i had to restart the service.

the network in not a domain its workgroup.
with sql server 2000 on win2k server.

any inputs are welcome.
thanks in advance
regards,
harshal.

View 5 Replies View Related

Express Vs Workgroup - Should I Upgrade?

Apr 26, 2007

Hello,

I am currently hosting my ecommerce site on a dedicated server with dual AMD processors and 2 gigs of ram. I have on average 20 people on the site at one time.

on this server i have sql express, from which i understand, only utilizes one of the processors and 1gig of ram. I have the choice to pay an extra 150 a month to have my host put sql workgroup on my system.

My question is, will i notice any kind of real performace boost by upgrading. Or at the level that i am at, there wont be much difference?

Any help would be very useful.

Thanks

View 5 Replies View Related

SQL 2005 Workgroup Vs. Standard

Jul 18, 2007

I would like to ask regarding sa performance difference between the two version of SQL 2005. Which is better the SQL 2005 workgroup or the standard edition..?

Darren Bernabe Blanco

View 1 Replies View Related

SQL Server On Windows XP Workgroup

Jul 23, 2005

We're running a simple network with a Windows XP Pro machine runningSQL Server. I have a VB application that runs fine on machines withinthe workgroup. There are several computers outside the workgroup butphysically reside on the network that generate OLEDB errors. I knowwith certainty it is establishing a connection to SQL Server. Theerror occurs on a SELECT statement. The user has read and writepermission to the database. I even tried giving the user Admin rightsjust as a test and it still generated the error. Is this a result ofthe cnmputer not being a member of the Workgroup? Thanks.Damon

View 4 Replies View Related

SQL Server And Workgroup Networks, How?

Jan 4, 2006

How to establish connection string for sql server on non-domain network?

View 2 Replies View Related

Trusted Security In A Workgroup

Jan 17, 2007

Good afternoon,so here is a question I've been struggling with that I thought folks onthe forum might have some wisdom kicking around on. I have severalproduction servers that are living within a workgroup where there is nodomain controler. However, I would still like to set up trustedsecurity for my asp.net applications. IIS is living on one server, andSQL server on another. Is there a way I can add a trusted relationshipto the machine and account that the IIS app is running under?My thanks in advance!Jonathan Wiggs*** Sent via Developersdex http://www.developersdex.com ***

View 1 Replies View Related

MS Sql Server On Workgroup Not Domain.

Jul 20, 2005

Hi have a small network setup and have MS sql server on workstation.Can access it locally but cannot access it from other work stations.I am assuming it is some sort of logon error, being it is not adomain. Any ideas on getting by this ?

View 2 Replies View Related

Log Shipping In Workgroup Environment

Jul 19, 2007

I have two SQL servers that I am trying to setup log shipping on. I am unable to get the restore of the initial database to work on the standby server. It gets a "unable to open file" error when trying to do the restore.







I have created a "syncaccount" user on both machines, and both have same password. I have used configuration manager to set the user/password for the agents on both servers.



I have given syncaccount admin access. I have added syncaccount to the shares on both servers.



Wy am I getting this error.



Does anyone else think it is VERY difficult to make this function work.

View 7 Replies View Related

SQL Express Or Workgroup? How Do I Tell What Is Installed And Where?

Apr 5, 2007

Hi guys,



I am a Systems Engineer and was sent on a job to a site that has a newly created SBS 2003 R2 Premium box which was OEM pre-installed from Dell. The SBS install was evidently finished off by the I.T. guys at the site. Now along comes some software house to install their propritery application. During this install process, the software guy was unable to find an instance of SQL running and installs SQL 2005 Express and the Express Studio management console. He installs his application and before he leaves says to the I.T. guys "Oh and by the way, there is a 4GB limit per database on SQL Express. You will have to change that to workgroup edition before the data grows too big. Have a nice day byeee!!!".



The I.T. guys go "Huh? Lets call James." So now I have to get this database off the SQL Express instance and onto a workgroup instance. I understand about detaching a database and re-attaching it. No prob there. What is confusing me is when I look at the default instance which should be a Workgroup instance, all I see is an Express instance.



What I am planning to do is rip out all the SQL 2005 stuff, leaving behind only Sharepoint, SBSmonitoring and WSUS stuff. The, using the SBS Premium cd's, install SQL 2005 again and updating the service packs for it again. Then mount the databases under it and get the software guys back in to reconfigure their application if need be.



Thing is, I have no idea how to sort it all out other than "Add remove programs" in control panel and remove the SQL 2005 stuff. What scares me however, is the thought of also removing the Sharepoint, WSUS and SBSMonitoring databases too.



Can someone help me with a procedure for sorting it out? How can I tell what I should uninstall and what I shouldn't? How do I tell if workgroup is already there and why did express steal the default instance?



Cheers

James



View 1 Replies View Related

Mirroring On Workgroup Servers

Apr 6, 2007

I have 2 web servers in a workgroup both running SQl 2005 SP2. both servers have a user called sqluser which is the main login for sql on both boxes. When I use the mirroring wizard it creates the end points ok but does not like the fqdn of each server, these are called webserver1 and webserver2. Is the problem because of the name and lack of domain ? Can I add a user for server1 on server2 or do I need to use certificates to get Mirroring working in this type of environment ?

View 10 Replies View Related

Upgrade From Workgroup To Standard

Jul 6, 2007

We have got the wrong version of SQL Server 2005 due to not having SSIS. We have loads of DTS packages running and I have tried to import them and its shows no SSIS service installed.

Is the route to upgrade straight forward? We have a couple of databases running on 2005 upgraded from 2000 but most still are active on 2000.

Cheers

Scott

View 1 Replies View Related

Is It Possible To Run A Website With Sql 2005 Workgroup?

Dec 3, 2007



I am a very beginner in setting sql server 2005.
I was not sure if sql 2005 workgroup edition supported online database when I compared on MSN comparison chart.
Does workgroup edition only work in local computers?
Can I install 2005 workgroup edition on a windows server and run a business website requiring database?Thanks in advance.

View 1 Replies View Related

Workgroup -&&> Domain Impersonation

Jul 8, 2006

In the following scenario, I am getting the message 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection'.

I am running a Windows Server 2003 with development environment and Sql Server Management Studio in a workgroup on a virtual PC.

My SQL Server 2000 is running on a domain server.

On the virtual Pc I have setup my user login and password to be the same as my domain login and password. Why is the Management Studio not using impersonation and allowing me to connect to the SQL server on the domain?

View 4 Replies View Related

Can't Connect To A Sql Express On A Workgroup Pc

Aug 8, 2007

Hi Guys,
I'm trying to connect to a sql express on a workgroup PC through sql server 2005 standard edition remotely but i can't.
I have checked and make sure that tcp/ip and other protocals are allowed. There is no firewall on both PCs and the sql browser service is running as well.
Somehow i can connect using the IP address but not the name?

Any idea why?

TA
Gemma

View 4 Replies View Related

SQL Server 2005 Workgroup Installation

Feb 3, 2007

HI All,
After i installed SQL Server 2005 workgroups edition to my Laptop, P4 and 1 Giga memory. I had a problem.
my problem is: when i start my laptop need 4 minutes to start the windows xp pro edition.
then I format my laptop and install the windows again, and every thing works fine, but I installed the SQL again and i had same problem with windows startup, there is nothing related to SQL in ;msconfig utilities.
do you have any tip about this problem ?
Thank You

View 3 Replies View Related

Replication, Workgroup, And Sharing NT Login

Nov 15, 1999

Would someone please tell my how to share the same NT Login on a Publisher and a Subscriber Server. For example, one of
the requirements for Replication is that the Publication Server and
Subscription Servers should share the same SQL Executive account. I tried
doing this in Control Panel, Services Applet, Startup, and This Account Box. The Subscribing Server is not allowing me to map the login of the Publishing Server. I also tried within NT User Manager for Domains. I am not able to figure this out. I am trying to get Replication to work within a Workgroup on two NT 4.0 Servers SP3, with SQL Server 6.5 SP5a.

Thanks, Kevin

View 2 Replies View Related

Sharing SQL Server Express Among Workgroup

Sep 27, 2005

Hello -- Please excuse my extreme newbieness -- trying to get up to speed fast on SQL Server Express for work. I've been able to set up the software, create a database, and access it with no problems on my local computer, but I need to make the database available to other computers in my workgroup. I followed instructions -- enabled TCP/IP and Named Pipes and turned on SQL Server Browser, and I was actually able to manipulate one system database (the "master" database) from another computer but not any other databases, not even the other system databases. I can connect to any of the databases with the SQLCMD commands, but if I try to do any SELECT commands (other than in "master") I get an error: "SELECT permission denied on object '[MyTable]', database '[MyDatabase]', schema 'dbo'". I was only able to get into "master" after adding "guest" as a user, but adding this user to the other databases has no effect. One interesting thing: When I used the sp_table_privileges command on each database, all but "master" showed all privileges being granted to and from "dbo", but "master" didn't show anything being granted to or from anybody. Does anyone know what could be going on here? Am I missing something obvious? Thanks for any and all help!

View 1 Replies View Related







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