How To Access Deployed SQL Express
Dec 1, 2006
Hi Msdn,
I have developed a program that required user to store information at their own machine (sql server express). So, i have included SQL Server 2005 Express Edition in the Prerequisites
When i try to deployed my program at test machine, the installer works fine, by installing the .net framework 2.0, then SQL Server 2005 Express Edition, then Finish.
When i tried to run on the test machine, my program showing me error "Open connection error". Well, i know somethings to do with my connection string,
Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True; Initial Catalog=abc;User ID=123456;Data Source=localhost
Logically, i do not understand how this things works.
my own developer machine contain Database Named "abc" with username and password "123456". The test machine do not contained any database nor username nor password.
How can i fix this problem? I mean some code to perform this operation without end user knowledge.
View 1 Replies
ADVERTISEMENT
Jan 30, 2007
How can we control the accesses to a SQL Server that has been deployed on customer site? Basically, we do not want user to log in the database server, even as sa, except through our application.
Any recommendation?
Thanks,
Xiaodoudou
View 3 Replies
View Related
Feb 17, 2007
I developed a site using Visual Web Developer 2005 and the database used is SQL Server 2005 Express edition.Everything works fine. However, when I move the site to my IIS server, it says that my database is read-only.Is it because my SQL Server is an express edition?
View 5 Replies
View Related
Sep 28, 2007
Hi,
We have the followoing:
-A "master domain" AD, a "sub domain" AD, a trust relationship between the two (sub trust master)
-A sql server 2005 on a win server 2003 in "sub domain" AD
-A linked server to "sub domain" AD
-A linked server login using a "sub domain" admin acccount
-A view to this linked server
-A grant on masterDomain/Domain Users to the database
-A grant on subDomain/Domain Users to the database
-We want all connections done through "Windows Authentication" not "Database Authentication".
Queries on the view work fine using "sub domain" user accounts.
Queries on the view fail using "master domain" user accounts (including master domain admin accounts)
"Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation."
All connections are done through "Windows Authentication" not "Database Authentication".
Can we establish cross domain connectivity with "Windows Authentication" ?
Below are details of the implementation:
SELECT TOP (100) PERCENT *
FROM OPENQUERY(ADSI,
'SELECT displayname, givenName, sn, cn (etc...)
FROM ''LDAP://OU=PEOPLE,DC=subDomain,DC=com''
WHERE objectCategory = ''Person'' AND objectClass = ''user'' ')
EXEC sp_addlinkedsrvlogin @rmtsrvname ='ADSI', @useself='false',
@rmtuser='subDomainAdminAccnt', @rmtpassword='sunDomainAdminAccntPassword';
In SQL Server Mngt Studio in Server Objects/Linked Servers/Providers/ ADSI properties security tab I have:
"connections will: <be made using this security context> Remote login:'subDomainAdminAccnt' With password: 'subDomainAdminAccntPassword'
Error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider indicates that the user did not have the permission to perform the operation.
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT displayname, givenName, sn, cn
FROM 'LDAP://OU=PEOPLE,DC=subDomain,DC=com'
WHERE
objectCategory = 'Person'
AND objectClass = 'user'
" against OLE DB provider "ADsDSOObject" for linked server "ADSI".
View 7 Replies
View Related
Feb 4, 2006
Looking for help in diagnosing this error:
Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatacartracker.mdf". Operating system error 32: "32(error not found)".
An attempt to attach an auto-named database for file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatacartracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I am using Visual Basic 2005 Express Edition along with SQL Server 2005 Express Edition.
Now here's what I did:
Rather than use the Database Explorer within VB2005 EE to create my database, I thought I would try creating my database externally using the downloadable "SQL Server Management Studio Express" tool. (I figured that if I had a stable data model for my database, I could side-step the copying/overwriting issues that come with creating a database as part of a VB solution.)
So having gotten my database setup and populated with some sample data, I am now trying to connect to it from Visual Basic. In VB (in the context of working on a VB Solution), I do the following:
Select Add New Data Source... from the Data menu to bring up the Data Source Configuration Wizard.
Choose "Database" for the data source type and click Next.
Click "New Connection..." to bring up the Add Connection dialogue.
For data source I choose "Microsoft SQL Server Database File", with ".NET Framework Data Provider..." as the data provider.
Navigate to my existing database file (in "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" folder).
Use Windows Authentication.
When I click "Test Connection" or just click "OK", i get the Microsoft Visual Basic 2005 Express Edition error shown at the top of this message.
Is this occuring because I'm trying to access my database as an .MDF file rather than through Named Pipes / Shared Memory / TCP/IP? If this is the case, is there any way that I can tell VB2005 EE to use Named Pipes / Shared Memory / TCP/IP? Is this a fundamental limitation of VB2005 EE?
Thanks in advance to the guru who is able to explain this to me...
View 8 Replies
View Related
Oct 16, 2007
I need to find a program that I can change my MS Access databases into SQL databases. My sites on the server are getting to many visitors and access is crashing the server. So I need to find a fast program that can covert a access database into SQL very quickly. I have not found one out there yet so any direction would help. I tried using the upsizing in access and that does not work on my machine so I would like a stand alone program.
Thanks for the help
View 3 Replies
View Related
Jan 11, 2007
Hello,
I need local database for my winforms application . In database will be stored c. 2000 records in 15 tables .
Is better use MS Access file or Sql Expres or something esle ?
Is working with Sql Expres faster then MS Acess (with c. 2000 records)?
Ondra.
View 4 Replies
View Related
Jul 16, 2007
i have an older asp web application (not .net) which connects to an access database and reads tables. the .mdb file resides on the web server, along with the asp page. the access db is going away, and the tables have been re-created in SQL express. I need to figure out how to connect and read the tables from either the existing non dot.net asp application, or a new php application.
I have read the post
FAQ: How to connect to SQL Express from "downlevel clients"(Access 2003, VS 2003, VB 6, etc(basically anything that is not using .Net 2.0 or the new SQL Native Client))some more fundamental questions are:
1) can I upload the the SQL express MDF file to the IIS server, and connect to it as a stand-alone file (like i could with the access mdb file)? *** note: SQL express NOT installed on this server, just the standalone mdf file uploaded)
1)a) if yes, what additional code will i need? i am unsuccessful in using the following connection string
set conntemp=server.createobject("adodb.connection")
connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=sonnys_inventory.mdf"
conntemp.Open connectionString
1)b) if no - i need to install SQL express on the IIS server. do i then upload the mdf file to the server and "attach" it through the SQL management program and follow directions in the post mentioned above?
thanks for any help.
View 1 Replies
View Related
Jul 23, 2007
Hi,
i am very new to databases. I use VWD 2005, Sql Server Express 2005 and have a remote database through a host rather than my own server. i have managed to create sql databases fine. Its with Access Databases Im really geting confused:
Can i use an access database I have created using VWD and sql server Express 2005? Or would it run just through VWD and the remote ?
If i use VWD I dont usually need to use IIS but if the latter of the two options is what I must do then i would manually need to create a virtual folder?
Nick
View 3 Replies
View Related
Nov 29, 2007
I just downloaded SQL Server Express from online and I'm unable to access it now. I cant make a connection nor can I create a database. Could anyone help me out with this and let me know what I've done incorrectly?
Thank you!
View 4 Replies
View Related
Oct 30, 2006
Can a database on SQL Express 2005 server be accessed remotely in a network?
View 4 Replies
View Related
Sep 14, 2007
Hi,
I've installed Visual Studio Express C# and Visual Studio Express Web Designer along with SQL Server. I've downloaded the example databases and have installed them - I can access the databases using the SQL Server tools.
When I try to access any SQL Server databases (specifically the Northwind example DB) via the Add Database Connection dialog in either C# or Web Designer, I get an error box with message "Exception has been thrown by the target of an invocation".
I get this when I manually enter Northwind in the Database Name field; if I try to browse, the whole dialog exits, or, sometimes Visual C# Express crashes. Since the same problem occurs both within C# and Web Designer, I'm assuming the problem is in SQL Server, which is why I'm posting in this forum.
I'm sure I have some configuration problem, and a complete uninstall/reinstall is certainly a possibility, but I'm hoping someone has an idea about how I can around this problem without having to reinstall.
Thanks for your time,
Larry
View 4 Replies
View Related
Aug 27, 2007
I have been developing a database application in MS Access that is intended for distribution. Before I go any further I would like to make sure that I should be using MS Access and not SQL Server Express. Can someone point me to a good source of information on this topic?
View 3 Replies
View Related
May 17, 2006
Does anyone know of a good set of instructions for correctly configuring a sql express server for web applications (the sql server and web server are on different machines). I can see the SQL server from my web server, but only using the sa account and I would like to know how I should setup another user and what rights to give this user.
View 1 Replies
View Related
Feb 21, 2007
Hi there,
I am totally new at SQL/SQL express.I have downloaded the sQL express server and wanted to know how i can go about exporting my tables which i created using MS access into SQL express.
Also my application is currently working by using Access and ASP...what will be the changes i would need to incorporate in my code other than the queries and Data connection string.
How would the data connection string in SQL look like if i am using it in my asp code?
Any help or useful links would be a very good help!
thanks in advance
smita
View 4 Replies
View Related
May 23, 2008
What would be the reasons for choosing (or not choosing) SSEE over say Microsoft Access in a Desktop application?
View 13 Replies
View Related
Mar 9, 2006
Hello,
I have sucessfully installed SQL Express, configured it for remote acess, created a working ODBC connection and can link tables from Access to SqlExpress. I am now trying to upsize an access database to SqlExpress. When I click "Use existing database" I get an Overflow error, no explanation is the wizard expecting like named tables with elements?
Any help appreciated.
Pat Backowski
Dublin, Ireland
View 4 Replies
View Related
Feb 17, 2006
Is there a way to integrate Access 2003 as the Front End for SQL Express?
I tried, but I can't make a new Access project because I need to specify a login/pass and I have no idea what those are set to, or if I need to make an account somehow.
As you can see, I am totally new to SQL and any help would be appreciated.
Thank You,
James
View 6 Replies
View Related
Nov 27, 2006
Dear folks
When I deploy an assemly into SQL Server using the Visual Studio IDE, it claims than it also deploys the source code to the server and the build process also shows deploying the files, but I can not find the files.
I am now developing on Windows XP and the SQL Server is also the Developer Edition on my PC.
Please help.
Parviz
View 3 Replies
View Related
Nov 24, 2006
I need to be able to update a database in SQL Server Express from an Access database that a user will be uploading. Can anybody give me some suggestions about how to accomplish this besides reading in each record and updating the SQL server one record at a time. David
View 1 Replies
View Related
Dec 15, 2006
Is there anyway to convert an SQL Express database to SQL server or Access format?
View 1 Replies
View Related
Jan 8, 2007
I need some help in converting this crosstab SQL from an Access query to a View in SQL Server Express:TRANSFORM First(tblPhones.PhoneNumber) AS FirstOfPhoneNumber
SELECT tblPhones.ClientID
FROM tblPhones
GROUP BY tblPhones.ClientID
PIVOT tblPhones.PhoneType;
View 14 Replies
View Related
Jun 14, 2007
I logged on to my SQL Server Express this morning and received the following error:
Cannot connect to MICHELLEWSQLEXPRESS.
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)
What is interesting is that its on a local computer. I followed one recommendation to enable the pipes and tcp but that didn't work either. How do I change the default settings to allow remote connections (on a local computer) when I can't log into the server?
View 2 Replies
View Related
Jul 23, 2007
I need some help upsizing from Access2007 to SQL Server 2005 ExpressI need some URGENT HELP UPSIZINGIf you have done this before and are confident, then please can you help me, This is critical and very very URGENT I am on a dedicated server at RackSpaceWhen I try and upsize using the Wizard, it said that it cannot connect to the database, I get error number I select Upsizing to create a new database On the next screen, I select (local) database to upsize toUsername and password are already confirmed and the user exists and has been granted Admin priv to operate on the DatabaseThe error I get is:SQL State 01000SQQL server state Error2Connection failedError 08001 connection failedError 17 When I list the databases it gives me an error as above.how do I upsize correctly, what steps am I missingRegardsAndrerw
View 6 Replies
View Related
Sep 23, 2007
I have recently started using VWD and SQl Express. I want to set up a catalogue of books on sql express of which there are three hundred which will then be presented on a web site. I already have most of the books on an access file. This may sound silly (I'm quite new to programming) but is there any way I can get sql express to extract information from the access file to save me writing it all out again?
Thanks
nick
View 3 Replies
View Related
Dec 7, 2007
Sorry if this has been answered before. Could not find any answers.
OS Vista Business, SQL Server 2005 Express.
I have a CSV file which I imported to Access only 100 records with 8 fields. Then ran Tools >> Database Utilities >> Upsizing Wisard. The result was I exported the table field headers but not the data. Is there any method on how I can get the field headers and data into SQL Server Express?
View 2 Replies
View Related
Mar 30, 2008
If this has been discussed before i apologise as i am fairly new to the asp forum and was not sure where to search for threads.
I am upgrading to a new web plan that supports asp and i noticed that godaddy supports all of the above databases. I was curious if there are any advantages to using one db over the others as far as web is concerned?
What i am looking to do is handle guestbook, logins for registered users which would control access to certain downloads and possibly pages as well. And it was also advised that i look into using a database to store and display dynamic information in my master page to only show the updated information instead of a complete new page each time. This would save on having to manage so many pages.
So i would really appreciate any advice on the databases as i will be making my decision to go with a specific web host based on this. I would also appreciate any advice on a good web host for asp and database support.
Thank you Jeff
View 2 Replies
View Related
Nov 29, 2005
Problem:Upsize a backend MSAccess 2002 Database to SQL Express 2005Explored:Tried using the upsizing wizard from Office XP(2002), Two tables always get skipped.***! The two tables skipped data only, the tablename and data structure were created.Tried to install UPSize Pro, installation failed.I decide to try it in VWD 2005, here is my code so far but it keeps erroring out.
Dim cn As System.Data.OleDb.OleDbConnectionDim cmd As System.Data.OleDb.OleDbDataAdapterDim ds As New System.Data.DataSet()cn = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:Documents and SettingsBillMy DocumentsVisual Studio 2005WebSitesWebSite1App_DataData for Database.mdb';Persist Security Info=True")cmd = New System.Data.OleDb.OleDbDataAdapter("select * from Service_Orders", cn)cn.Open()cmd.Fill(ds)cn.Close()
Dim connDest As New Data.SqlClient.SqlConnection("Data Source=WLOCKLAPTOPSQLEXPRESS;Initial Catalog='Data for DatabaseSQLND1';Integrated Security=True")connDest.Open()Dim oBCP As New Data.SqlClient.SqlBulkCopy(connDest)oBCP.DestinationTableName = "Service_Orders"oBCP.WriteToServer(ds)oBCP.Close()connDest.Close()
It erors on Line oBCP.WriteToServer(ds)with......System.InvalidCastException was unhandled by user code Message="Unable to cast object of type 'System.Data.DataSet' to type 'System.Data.IDataReader'." Source="App_Web_hb6xyamq" StackTrace: at ASP.xfer_data_aspx.Button1_Click(Object sender, EventArgs e) in C:Documents and SettingsBillMy DocumentsVisual Studio 2005WebSitesWebSite1xfer data.aspx:line 30 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)I'm open for ANY suggestions, I do not have access to DTS, its not in the Express addition. Thanks in advance.Bill
View 2 Replies
View Related
Jan 20, 2006
Hi everyone, im having alot of trouble trying to execute a stored proc from sql express. heres my code
DbProviderFactory db = DbProviderFactories.GetFactory("System.Data.SqlClient");
using(DbConnection conn = db.CreateConnection()){
ConnectionStringSettings s = ConfigurationManager.ConnectionStrings["constrolservicetest"];
conn.ConnectionString = s.ConnectionString;
conn.Open();
DbCommand cmd = conn.CreateCommand();
cmd.CommandText = "StoredProcedure1";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param = db.CreateParameter();
param.ParameterName = "@test";
param.Value = 2;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
}
****************************procedure code***************************
Create PROCEDURE dbo.StoredProcedure1
(
@test int
)
AS
Update temp
Set test = @test
******************************************************************
The code just doesn't update. I know my connection string is correct because i got the datareader to work, but i just cant get the stored proc to call. Any help will be greatly appreciated.
Thanks,
-D
View 1 Replies
View Related
Dec 12, 2005
Guys,
Do you have articles on this? this is for my reference.
thanks!
View 1 Replies
View Related
Dec 13, 2005
RD writes "Do you have a comparative article on SQL Express and MS Access?"
View 2 Replies
View Related
Feb 9, 2006
I didn't want to cross post but I was not sure if this or the access forum is the right venue for this question. Please read post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61270. I have not had a response in that forum.
View 1 Replies
View Related
Aug 7, 2006
Hi,
I was wondering if anyone might be able to help me here. I'm very new to SQL server and has been asked to convert microsoft access database .MDB to SQL server. In another word, i'd like to migrate access to SQL Server. It's not a huge database. The size of it is roughly 6MB. The reason for migration is simply because our clients don't have microsoft office running on their system. They use SQL Server. This's a new challenge to me as i'm more comfortable with using Access now.
I have been searching and studying it thru the online tutorial about what it's and what it does. I have also downloaded and installed the SQL Server 2005 Express edition because it has GUI Interface and it does have the ability to produce reports like Access does. Now my question is how do i start because when i created the database i didn't think of any client/server application? so if i want to run the Access, i just double click it and start using it. how do i migrate it to SQL Server for a testing sake?
I really need some guidance here please.
Thank you in advance
View 6 Replies
View Related
