Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Local Database Access Issues


Hello,





I have a local SQL Server database installed with Visual Studio .NET. I'm trying to create a SQL Server login ID to access a database on this local database. I gave it access to all of the databases with public (the one I'm using it also has DBO and execute permissions on all procs). When I try to login to it through SQL Server Query Analyzer (and also using an ASP.NET application), I get the following error:





Login failed for 'dbuser'. Reason: Not associated with a trusted SQL Server connection.





How do I set up a SQL Server login to access the database?





Thanks,





Brian


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Database Access Issues
I'm running a simple login application locally with SQLExpress.  If I run it straight out of VS2005 it will allow the user to login successfully, however if I run it through IIS it gives me the following error.
Server Error in '/BasicReview' Application.


An attempt to attach an auto-named database for file C:Documents and SettingsjmfosterMy DocumentsVisual Studio 2005ProjectsBasicReviewBasicReviewApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
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: An attempt to attach an auto-named database for file C:Documents and SettingsjmfosterMy DocumentsVisual Studio 2005ProjectsBasicReviewBasicReviewApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:



[SqlException (0x80131904): An attempt to attach an auto-named database for file C:Documents and SettingsjmfosterMy DocumentsVisual Studio 2005ProjectsBasicReviewBasicReviewApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

View Replies !   View Related
Database Access Right Issues
Recently I have changed the VB Application for Authentication methodto connect to the SQL Server 7.0 database using the Windows NTAuthentication.Later I had created permissions for Select, Insert, Update, Delete,Exec everything based on the Windows NT Authentication on an ActiveDirectory Group based.Now I am trying to use the application from the Windows 2000 machine.It runs normal with the all rules applied.When I run from a windows 98 PC. It connects to the database withoutany problem. When I tried to run the transactions or reports, Itthrows the error as either Permission denied or Runt-time Error '13'Type mismatch like that.Can anybody tell me the work around for this issue?I doubt this is something do with OS incompatiblity to access databasetables from Windows 98. Where as it is ok with Windows 2000.Thanks in advanceSaravanakumar

View Replies !   View Related
How To Access Remote Connections For A Local Database?


Hi 2 All,

I have installed MS SQL 2005 in my system. I have created one database in my server. When iam running my application with this connections it is working fine in my local system. When i uploaded the database to some where dataserver, Iam not getting the connectins due to no remote access .

Some body suggested that to start the SQL browser in the SQL Server Configuration Manager.

I go there n tried to start the service when iput the service properties to Automatic or Manual i am getting the error messagethat is saying that the service is disabled cannot start automatically.

What could be the wrong?

Please suggest me.
Thanks and regards,

View Replies !   View Related
Is It Possible To Have A Website Remotely Hosted, Which Would Access Local Database?
Hi everybody,
Currently we have a MIS application, developed in VB 6.0 - SQL Server 2000 platform, which is used by around 60 users in our office.
We are planning to host a website remotely, which would allow clients to place orders, track order status etc. on it.
Would it be possible to access our local SQL database from the remote website?
 

View Replies !   View Related
Cross DB Dialog Security Issues. Was: Can't Route To Another LOCAL Broker Instance
Hi Remus,



I am experiencing the same problem, and I can't get the easy fix to work. I drop and create the DB's in between tests, so it is not related to having an old certificate in the DB, as in the case of Tilfried.



The situation is as follows:

DB1 owned by login1, hasa user for login2; this DB is for the initiator

DB2 owned by login2, has a user for login1; this DB hosts the target

Both DB's have TRUSTWORTHY flag set to ON

Error in sys.transmission_queue: 'Error 916, State 3: The server principal "Login1" is not able to access the database "DB2" under the current security context.



Going on a limp, I decide to add a remote service binding in DB1, binding the user for Login2 to the target service, even though BOL explicitly states that this is only required for cross-server communications.This does change the situation - I still get an error, but a new message is sys.transmission_queue: "Dialog security is unavailable for this covnersation because there is no certificate bound to the database principal (Id: 5). Either create a certificate for the principal, or specify ENCRYPTION = OFF when beginning the conversation." I already know that the first option works, but I wanted to get the simple solution running. As for the second option, I doublechecked and the initiating procedure DOES already specify ENCRYPTION = OFF in the BEGIN DIALOG CONVERSATION command. My theory is that the remote service binding somehow forces SB to use encryption, but (a) that is not stated in the error message, and (b) if so, then how to get the messages sent over to the target service without using the binding?



==> EDIT: Just saw that you confirmed this theory in your last reply to Tlifried. So I am indeed back to having to find out how to get this to work without remote service binding - it should be possible, but how???



BTW, SELECT @@VERSION shows that I'm on build 3054, in case it matters.



Between all the errors in BOL andless thanhelpfull errormessages produced by SB, I feel like I'm slowly losing my sanity. Please help!



Best regards,



Hugo Kornelis

View Replies !   View Related
Not Able To Connect To The Local Database With (local) As Server Name
I am facing a problem in connecting to the local database with server name as (local).

I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.

if anyone can help me what is the problem in this case it is highly appriciated.

View Replies !   View Related
Need Help - Local Synchronization Between SQL Mobile And Local SQL Database
Hi Everyone

I am at the stage of architecting my solution

My goal is to develop the system on a windows application and pda

There is a central server which will create a publication called inventory

The laptops which host the windows application will be subscribers to the central server using merge replication

The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server

I have been reading for days and I am still unsure whether this is possible to do.

I know Appforge provide a conduit for palm to access synchronization but not local sql databases

I would appreciate your help immensley

View Replies !   View Related
Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive
Being a very novice SQL Server administrator, I need to ask the experts a question.

How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?

Thanks,
Rick

View Replies !   View Related
Can Not Access Local DB
I have a local SQL2000 instance on my PC and cannot get in. I am running windows 2000 with active directory. I used to open the database using windows authentication. I recently had to change my password. I do not know if this has anything to do with the problem. I have tried everything, using windows authentication, using my login with old password, login with new password, sa account. Does anyone know how I can get in or how I can remove this instance and create a new one?

Thanks,
Ken Nicholson

View Replies !   View Related
Can't Access (local) Server
I folks. I have something going on with my local SQL instance. It's SQL 2000 Standard with SP3a on a W2k3 Server with SP1. It's been running fine for several months. I got brave over the weekend and broke something.

I installed the .Net Enterprise Architect and SQL Reporting Services. My SQL instance is still running, but I can't get to it through EM and SQLServerAgent won't start. When I try to start SQLServerAgent manually, it gets about halfway through the process, then shuts itself down again. I also have an MSDE instance that is not complaining at all.

I can get to the server from my applications. I can also register it in EM with the IP and get to it that way.

Here's what's in sqlagent.out:

2007-01-02 16:34:41 - ! [298] SQLServer Error: 6, Specified SQL server not found. [SQLSTATE 08001]
2007-01-02 16:34:41 - ! [298] SQLServer Error: 11004, ConnectionOpen (Connect()). [SQLSTATE 01000]
2007-01-02 16:34:41 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2007-01-02 16:34:42 - ? [098] SQLServerAgent terminated (normally)


I did confirm in the registry that the port is set to 1433. It's not blank or incorrect. I am also working with a local account that is in the administrators group. There is no AD structure at work.

Many thanks for any ideas. This one feels like a little needle in a big haystack.


Eagles

View Replies !   View Related
DTS Package Issues With Access
Hello,

I kick off a DTS package with ASP.NET. I'm getting an error stating:

The Microsoft Jet database engine cannot open the file <path>. It is already opened exclusively by another user, or you need permission to view its data.

The DTS package is pushing data from Excel to Access, and then Access to SQL. When running the process, I run it directly and it works fine. I haven't tested it through scheduling yet. All of the information on the web says security permissions, but I impersonate the ASP.NET page to use another account, which has full access to the access database and dbo to SQL Server.

Any ideas?

Brian

View Replies !   View Related
Access SQL Conversion Issues?
Hi there, apologies if i have entered this into the wrong forum.

I am currently building an application using microsoft access and coding in VBA (what i can!)

When i have got it working as i like after user testing i would like to create an MDE file to distribute to users and i would like to convert the access database held on a file server to a SQL server but have no experience of doing this.

In what order would i do this and would i suffer a loss of functionality in changing from access to SQL i.e. would some of the VBA code not work in SQL?

Thanks for your time,

Rhys.

View Replies !   View Related
Local Cube Access Is WAY Slow
I have created a local cube from a SQL data warehouse table using the both the Excel only method and Analysis Services. When dragging and dropping "Row Items" dimensions the cube preforms fine until I get the 4th dimension in the row area and then the Query takes FOREVER to process, if it finishes at all. The table the cube is created off is not that large only 8500 records and my machine is pretty quick 2.53 P4, 512MB RAM. The table has one clustered index on it based off 5 columns. Now I'm just going in circles and hopefully overlooking something stupid. Anyone have an idea?

View Replies !   View Related
Can't Access Instance Of Local Webserver
Hi, I've installed SQL Server 2005 Express Edition, SQL ServerManagement Studio Express using Windows Authentification and IIS 5. The problem occurswhen I try to access the default address of my local computer to test my installation. I've tried with both http://localhost and http://127.0.0.1. The system requires a password despite I don't use password for my Windows Authentification. Does IIS always demands a password regardless mysettings forWindows Authentification or?

Best regards

View Replies !   View Related
Only Local Access To SQL Server 2005 Express Ed. ?
Hello!
I run an application with a SQL Server 2005 Express edition.

I read under

Start menu
--> all programs
--> Microsoft SQL Server Express
--> Configuration Tools
--> SQL Server 2005 Surface Area Configuration
--> Surface Area Configuration for Services and Connections
--> Database Engine
--> Remote Connections

That:
"By default, SQL SERver 2005 Express, Evaluation and Developer editions allow local client connetctions only. Enterprise, Standard and Workgroup editions also listens for remote client connections over TCP/IP. Use the options below to change the protocols on which SQL Server listens for incoming client connections. TCP/UP is preferred over named pipes because it requeres fewer ports to be opened across the firewall."


Here I chose the option "Local and remote connections only, using TCP/IP only".


But still, does this mean that other users can't connect to my database since I'm running the Express edition?

If that's the case, could this be changed by using mySQL instead?

Is it hard to transfer a MS SQL Server .mdf database file into a new mySQL database?

View Replies !   View Related
Bulk Insert -- Access Denied Issues
Problem: Insert a network file in the DB using BULK Insert

View Replies !   View Related
Bulk Insert -- Access Denied Issues - 2
Hi All
Same situation as described here , same issue.
SQL Server(SQL2005 on Windows2003)uses domain account. This domain account enabled to be trusted for delegation. Client connects to server using Windows auth. Client issues BULK INSERT with UNC path. Statement returns error:

Cannot bulk load because the file "\Serverpubfile.txt" could not be opened. Operating system error code 5(Access is denied.)SQL 2000 runs this statement successfully so statement and file are OK. Everyone has all permissions on network share. Domain account granted all permissions explicitly so there is no access troubles.
Audit show anonymous connections.
Question is - how to put delegation in work?

Thank you in advance,
Alexander Sinitsin

View Replies !   View Related
Security And Access Rights Using Local And Global Groups
We've set up an SQL Server 2000 (build 8.0.761 - I think that's SP3)access control scenario like the one described in this article:<http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec01.mspx>,but can't get it to work in all the cases we have need for.Specifically, we have a domain controller with two objects defined:* a user (call him Fred)* a global group (call it Inventory group)and an SQL Server machine in the domain having a local group, callit "Data Access Group". The Inventory global group is a member of theglobal Data Access Group. SQL Server allows both logins and rights tomembers of the Data Access Group.However, in this scenario, Fred cannot login. Adding Fred to theData Access Group allows the login, but the transitive membershipvia the Inventory group doesn't allow it. This is definitely *not*the behaviour described in the above article.On another similar setup, the SQL Server is installed on the DomainController, and in this case, the access is granted.Can anyone help me understand what's going on here, and explain howthis stuff can be made to work with transitive group memberships?Clifford Heath.

View Replies !   View Related
Data Access In Local Network Ms Sqlserver 2000
Hi, i need some help, i have a problem trying to access data in my local network.

I have a PC with ms windows server 2003 and ms sql server 2000, and i want that the others PC in the network can access the data. I installed the client sql server in the others PC, but i can't make it work. What i have to do?

Thanks

View Replies !   View Related
Cannot Use Host Alias To Access Local Report Server
We have an application that uses a generic host alias in it's URL to the Report Server, fx:
http://RepSrv/Reports
Thus, we can use DNS or the local hosts file to direct the client app to use what-ever-the-real-name-of-the-server-may-be.

This works excellent, except from the Report Server itself.
It's hosts-file has an entry like this: "10.0.0.10 RepSrv"

Now from this server, if I ping RepSrv I do get a reply from 10.0.0.10.
Furthermore, I can start IE and access http://10.0.0.10/Reports, or http://<real-host-name>/Reports, or http://localhost/Reports.
- But why, why, why can we not access http://RepSrv/Reports, when using that very same url from a client works like a charm?!

Is there just some server configuration missing?
I hope we're not the only ones with similar needs, and that some of you have already found a solution to this.


Espen Sandall

View Replies !   View Related
SQL 2005 Express Local Admin Access Denied
I am using a standard installation of SQL 2005 Express installed with Visual C# Express. I have tried several connection strings, have tried connecting different databases, all of which end up giving me access denied for user <machineName>Greg (Greg is the local admin account for this PC. I found this guideline for connectivity questions (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1), and have gone through it all, posting the answers to questions here. One thing that may be different about this machine is that it is a tablet PC (WinXP Tablet edition) and I am running VMWare Server. I also tried loading it on a WinXP Pro workstation with no VMWare, and have gotten the same results. Any help will be greatly appreciated.

My connection string:
@"Server=(local);Integrated Security=SSPI;Database=Database1");

Client error message:
Cannot open database "Database1" requested by the login. The login failed. Login failed for user 'GREGBORGGreg'.

Client is local to the SQL 2005 Express - this is an application running on a local PC.

I am able to ping -a GREGBORG (as well as localhost)

I am able to telnet to port 1433 of my local machine, although Ctrl+[ does not give me an SQL prompt

I am using ADO.NET 2.0 and Visual C# 2005 Express

I have enabled Shared memory, named pipes and TCP/IP.

I have no alias' configured, and am not requiring encryption.

=========================
I am using SQL 2005 Express loaded on Windows XP tablet edition.

The SQL browser is not enabled, and it says that it has no enabled devices associated with it.

SQL Server is running under the Network System account

I have tried running it firewalled and not firewalled

I am running Clamwin anti-virus


From the ERRORLOG:
2007-01-03 12:29:56.19 Logon Error: 18456, Severity: 14, State: 16.
2007-01-03 12:29:56.19 Logon Login failed for user 'GREGBORGGreg'. [CLIENT: 10.101.1.200]

From the command prompt I get:
C:Documents and SettingsGreg>osql -E -S (local)sqlexpress
1> use Database1
2> go
Msg 911, Level 16, State 1, Server GREGBORGSQLEXPRESS, Line 1
Could not locate entry in sysdatabases for database 'Database1'. No entry found
with that name. Make sure that the name is entered correctly.

When I try to attach Database1 in my 'My Documents' folder, it says that access is denied to the file.


I added a user via SQL Management Studio Express and then received the error:

C:Documents and SettingsGreg>osql -S gregborgsqlexpress -U Greg -P ********
1> sp_attach_db "Database1", "C:documents and SettingsGregMy DocumentsVisual
Studio 2005Projects est_SQL est_SQLDatabase1.mdf"
2> go
Msg 5133, Level 16, State 1, Server GREGBORGSQLEXPRESS, Line 1
Directory lookup for the file "C:documents and SettingsGregMy
DocumentsVisual Studio 2005Projects est_SQL est_SQLDatabase1.mdf" failed
with the operating system error 5(Access is denied.).
1> use northwind
2> go
Msg 945, Level 14, State 2, Server GREGBORGSQLEXPRESS, Line 1
Database 'Northwind' cannot be opened due to inaccessible files or insufficient
memory or disk space. See the SQL Server errorlog for details.

In the ERRORLOG I have:
2007-01-03 12:38:27.25 spid51 Error: 5173, Severity: 16, State: 1.
2007-01-03 12:38:27.25 spid51 One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
2007-01-03 13:07:16.82 spid51 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2007-01-03 13:09:24.68 Logon Error: 18456, Severity: 14, State: 8.
2007-01-03 13:09:24.68 Logon Login failed for user 'Greg'. [CLIENT: <local machine>]
2007-01-03 13:09:27.43 Logon Error: 18456, Severity: 14, State: 8.
2007-01-03 13:09:27.43 Logon Login failed for user 'Greg'. [CLIENT: <local machine>]


Again, thank you for any help. I think I may have been staring at this too long to be productive any more...
--Greg

View Replies !   View Related
SQL Views Accessed In MS Access Via ODBC (Blocking Issues)
Hello,

We have allowed one of our clients to create views in our .net /sql application so they can build reports using MS Access. They have been doing so successfully for years. However lately they are experiencing Timeout Expired messages when in the actual web application. I have confirmed that several of the views when opened in Access do cause blocking, the locks are promptly realeased when the the access odbc of the sql view is closed.

When the views are opened in SQL query analyzer, there is no sql blocking.

Would this be related to how the tables are linked?

Any suggestions would be greatly appreciated.

View Replies !   View Related
How To Access Or Modify Local Subscriptions Data In Merge Replication
Hello,



If I want to access or modify my local subscription data(not the configuration) how can I do that(from sql server 2005 or from asp.net)? Also can i update directly to the local subscriptions data ordoIneed another layer which will update from a table for example??



Thank you



Salah

View Replies !   View Related
Access Can't Link To NEW LOCAL SQL Server 2005 Express Installation
I have just downloaded and installed the SQL Server 2005 Express version, enabled TCIP and Named pipes but when I try to link to the tables with Access 2003 or try to create a database connection I get an error 17 "connection failed - SQL Server does not exist or access is denied".

I am able to open Management Studio Express and see all of the databases, including another SQL Server 2005 server that I have. I am able to Link to my other server but I can't get see my local install.

What can I do?

Thanks,
Mike

View Replies !   View Related
Import Wizard - Using Query For Remote Database To Compare Local Database
I am trying to use the Import Wizard to setup a daily job to import new records based on anID field (PK). The source database is remote and a replica. I am inserting new records to update my table called the same thing. Both are SQL Native Client


Code Snippet
select *
from [CommWireless].[dbo].[iQclerk_SaleInvoicesAndProducts] as S1
join [IQ_REPLICA].[dbo].[iQclerk_SaleInvoicesAndProducts] as S2
on S1.SaleInvoiceID = S2.SaleInvoiceID
where S1.SaleInvoiceID > S2.SaleInvoiceID


When I parse the query, I keep gettingan error message.

Deferred prepare could not be completed.
Statement(s) could not be prepared.
Invalid object name 'IQ_REPLICA.dbo.iQ_SaleInvoicesAndProducts'. (Microsoft SQL Native Client)

Anyone know an easy why to get this to work? Or should I add a create table toverify new records?

View Replies !   View Related
How Do You Copy Tables From Local Database To Web Hosting Database In 2005?
I'm using SQL Server Management Studio Express and I'm trying to figure out how to copy a table(s) from my local database to my web hosting database.  I know how to do it in 2000, but it's completely different now.  Is this feature not allowed on SSMSE?  If so, then how do I deploy database tables to a web host?Also, how do you add local database(s) to SSMSE?  I tried to use 'attach database' in SSMSE and it wouldn't allow me to navigate to My Documents folder where the database resides. Thanks...

View Replies !   View Related
Updating Online SQL 2005 Database From Local Database
I have my first small SQl Server 2005 database developed on my localserver and I have also its equivalent as an online database.I wish to update the local database (using and asp.net interface) andthen to upload the data (at least the amended data, but given thesmall size all data should be no trouble) to the online database.I think replication is the straight answer but I have no experience ofthis and I am wondering what else I might use which might be lesscomplicated. One solution is DTS (using SQL 2000 terms) but i am notsure if I can set this up (1) to overwrite existing tables and (2) notto seemingly remove identity attributes from fields set as identities.I know there are other possibilities but I would be glad of advice asto the likely best method for a small database updated perhaps onceweekly or at less frequent intervals,Best wishes, John Morgan

View Replies !   View Related
Replication - Changes To Server Database's Impact To Local Database
We have a SQLSERVER database that is replicated to many users.We are currently in an expansion phase where we need to make changesto the server database. Each time we rollout a new release, we aredeleting the local replicating database and recreating.Is there any way to automatically transfer the changes from the serverto existing local database without deleting?

View Replies !   View Related
Updating A Table On My Hosted Database From A Local Database
Hi,

How do I insert data that I have collected in a local database onto a table on my online ie hosted database which is on a different server?

At the moment I am just uploading all the data to the hosted DB but this is wasting bandwith as only a small percentage of data is actually selected and used.

I thought that if i used a local DB and then update the table on my hosted DB this would be much more efficient, but I am not sure how to write the SQL code to do this!

Do I do some kind of

INSERT INTO sample_table

SELECT xxx

FROM origanal_table



Or is it more complicated than this?

Thanks

View Replies !   View Related
Database Access Via COM Objects - V- Database Access Via Stored Procedures
We have been asked to look into using stored procedures with SQL Server 7.0 as a way to speed up a clients site. 99% of all the articles I have read along with all the books all say Stored Procedure should be used whenever possible as opposed to putting the SQL in your ASP script. However one of my colleagues has been speaking to Microsoft and they said that that they were surprised that our client wanted to use Stored Procedures as this was the old method of database access and that now he should really consider using COM objects for data access as itis much faster. Has anyone got any views on this or know of any good aticles regarding this matter ?

View Replies !   View Related
How To Import From External SQL Database To Local SQL Database
Hello everyone. I have two machines that have SQL Express on them. Ihave developed a SQL database with two tables, and a lot of data, on mylaptop. I want to copy that database and make it available to my localdesktop machine. How can I export or save the database on the laptopand then import it so that I can use it on the desktop?

View Replies !   View Related
How To Sync Local Database With Network Database
Hi

Scenario: In generaluser will take database backup from database server to local system. User perform some changes to his local database based on his requirement. Again user connects to database server and click on update,local database should update to server database by informingeach record status to the user.ex: record 1 updated / call closed do you want to update?

Here local database is going to be Pocket pcdatabase and server database is on SQLDatabase. Can any one suggest best way to implement this feature in Windows Pocket pc, c#. I would appreciate your reply.

Thanks,



View Replies !   View Related
Get Database To Local Machine
What is the fastest way to get a copy of a SQL server database on a server to my local Windows XP Professional system?

View Replies !   View Related
I Can't Connect To My Local DataBase Please Help...
 
DBconn.cs
 
  private DBConn()  {   //   // TODO: 在這裡加入建構函?的程?碼   //   this.Server=Property.getProperty("DBServer");   this.port=int.Parse(Property.getProperty("DBPort"));   this.User=Property.getProperty("DBUser");   this.Pwd=Property.getProperty("DBPwd");   this.db=Property.getProperty("DBDatabase");   this.ConnectionString="server=" + this.Server+","+this.port+";database="+this.db+";uid="+this.User+";pwd="+this.Pwd+";Connect Timeout=60";        }
--------------------------------------------------------------------------------------------------------
propetry.config
  <property name="DBServer" value="127.0.0.1" />  <property name="DBPort" value="1433" />  <property name="DBDatabase" value="CSLC" />  <property name="DBUser" value="CSLCUser" />  <property name="DBPwd" value="resslc" />
 
 
I use this way to call my connecting string , but I can't connect to my local DataBase , I trid to modify the  propetry.config to coneect to other DataBase on other Server it works
only when Connecting with my Local DataBase , it not work...
 
this problem have been troble me more than 3 weeks... ask many people no one can resolve this problem...
when I am at home . I can't work... because I can't connect to the Server when I'm in office..
 
pleaes help... thank you very much
 
 

View Replies !   View Related
Local SQL Database Permissions
My webapp has a local database in the same directory.  When I debug in VS2005 all works perfectly.  When I try to run outside of VS2005 I have no luck.  First I was getting the error that the database was read only.  Then I attached with SQL Management Studio, and set permissions to the ASPNET account to access the database and detached, but now the error is that login failed for the ASPNET account.  How are permissions supposed to be set for databases in the AppData directory like this in order to work?
 
Thanks for any help

View Replies !   View Related
Installation Of Local Database
I have installed SQL Sever 2000 on my Windows XP Pro machine from theEnterprise Edition setup and it prompts you that only the client toolscan be installed. I wanted to have a local database as well So whatinstall should I have used to do so. Any information would greatly beappreciated.

View Replies !   View Related
Cannot Connect Local Database
Hello,

After restarting the machine, the sql 2000 won't start.

- I'm using local (no domain)
- administrator account
- sql agent is started, but cannot connect

a connection could not be establish to (local)
please verify the sql server is running and check your...

sql log below:

2008-02-07 11:34:53.04 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2008-02-07 11:34:53.04 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-02-07 11:34:53.04 server All rights reserved.
2008-02-07 11:34:53.04 server Server Process ID is 3088.
2008-02-07 11:34:53.04 server Logging SQL Server messages in file 'C:Arquivos de programasMicrosoft SQL ServerMSSQLlogERRORLOG'.
2008-02-07 11:34:53.06 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2008-02-07 11:34:53.14 server SQL Server configured for thread mode processing.
2008-02-07 11:34:53.17 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2008-02-07 11:34:53.17 server Attempting to initialize Distributed Transaction Coordinator.
2008-02-07 11:34:55.21 spid4 Starting up database 'master'.
2008-02-07 11:34:55.48 spid4 Server name is 'SUPORTE_SERVER'.
2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 23
2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 31
2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 32
2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 34
2008-02-07 11:34:55.48 spid5 Starting up database 'msdb'.
2008-02-07 11:34:55.48 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2008-02-07 11:34:55.48 spid6 Starting up database 'model'.
2008-02-07 11:34:55.49 spid8 Starting up database 'pubs'.
2008-02-07 11:34:55.49 spid10 Starting up database 'Northwind'.
2008-02-07 11:34:55.49 spid11 Starting up database 'Umuarama'.
2008-02-07 11:34:55.49 server SQL server listening on 192.168.0.101: 1433.
2008-02-07 11:34:55.51 server SQL server listening on 127.0.0.1: 1433.
2008-02-07 11:34:55.51 spid12 Starting up database 'adm_clube'.
2008-02-07 11:34:55.51 spid13 Starting up database 'Geracao'.
2008-02-07 11:34:55.51 spid14 Starting up database 'Sim_Externo'.
2008-02-07 11:34:55.51 spid15 Starting up database 'OPEN'.
2008-02-07 11:34:55.53 server SQL server listening on TCP, Shared Memory, Named Pipes.
2008-02-07 11:34:55.53 server SQL Server is ready for client connections
2008-02-07 11:34:56.25 spid6 Error: 9003, Severity: 20, State: 1
2008-02-07 11:34:56.25 spid6 The LSN (5:348:1) passed to log scan in database 'model' is invalid..
2008-02-07 11:34:56.84 spid10 Starting up database 'SISCONTACOR'.

Thanks

View Replies !   View Related
Backing SQL Database To Local PC
How can I do a backup of my SQL server database?

When I select 'Backup' can i change the destination path to my PC.


Regards

View Replies !   View Related
SQL Server Local Database


I have SQL Server Management Studio. I can access some databases to which I have been given access to. How can I create a sample database to which I can upload excel files as data fields.

This is for testing purposes. Any help appreciated.

Kiran

View Replies !   View Related
Using Local Reports That Hit A Database
I have a bunch of reports that I need to display. I've designed the reports using the Report Designer. Basically what I want to happen is to view the reports in local mode with the report viewer, but have them hit the database to get the values. I've designed them all with the database, I just don't want to go through all the hassle of setting up a report server. Plus, I've got a demo later this week so time is kind of a factor. Is what I'm trying to do possible? I really need help as the demo is this week

View Replies !   View Related
Download Database To Local And Use
I have SQL database hosted by my ISP. Every now and againwelog on and create new tables using user XXX1. After getting a backup of the database, I have restored it on my local machine. When running the application on local, I get an error because there is a new user in database called XXX1.

I would like to change the user from XXX1 to dbo on my local machine for all tables, stored procedures and views. How do I do this easily?

Thanks in advance!

Dave

View Replies !   View Related
A Few Database Issues
A few questions:1. What is better security wise: sql authentication or windows authentication?2. If I use windows authentication, which account is normally used for access? and how do I set this in the database as well as the web.config?(I test locally, but when I place the live site at my hosting provider I want to make sure that the windows account I used for testing is supported by them)Thanks!PS. SQL Server is driving me crazy with its no-helping-weird errors...(or is that just me? ;) ) 

View Replies !   View Related
New Database On Other Local Network Drive
Hello,
I need help with the setup of my sql server express 2005 and more specifically, with the location of the database files.  Normally, database files are located on the c: drive.  In my situation, being in a high school environnement, I need to have the database files on the network drive ... lets call it g:drive.  The reason why it cannot be on c:drive is because this drive is protected using DeepFreeze.  Now, I was able to change the location of the new drive as I went into the properties window of the sql server instance but when I try to create this new database, sql gives me grief  ;-|
 I am from the group of people that thinks that to anything, there is a solution and am hoping that to this problem, there is hope of a solution.
 Can anyone help?
 Thank you 

View Replies !   View Related
(local) Database Wont Start?
I dont know how this happened but my (local) SQL Server wont start. I cant access any of the databases. I just get this error:

'A connection could not be established to (local).

Reason: SQL Server does not exist or access denied.
ConnectionOpen (Connect())

Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.'

If I go to check the properties I get the same error. Im completely locked out. I looked at the folder and the database files are there, but I cant get to them through Enterprise Manager.

I have no idea how this problem could have happened. It just seemed to have stopped working. All my other databases can be reached (they are external). Could this be a virus or something? Can someone help me out on this one? I dont have a clue what the problem is, much less how to fix it.

Thanks.

View Replies !   View Related
Create Database Using Local Variables
I have an installation script and want to create a database based on some data in a table (config). Testing the script though I get a message:

Msg 170, Level 15, State 1
Line 12: Incorrect syntax near '@DBData'.

The relevant sql is:

declare @DBName varchar (40)
declare @DBData varchar (40)
declare @DBLog varchar (40)
declare @DBSize int
select @DBName = obj_txt from config where obj_nm='DBName'
select @DBData = @DBName + '_Data'
select @DBLog = @DBName + '_Log'
select @DBSize = obj_int from config where obj_nm='DBSize'
raiserror('Creating Database %s ....',0,1,@DBName) with nowait

Create Database @DBName
on @DBData = @DBSize
Log on @DBLog = @DBSize

I don't think there's anything wrong, apart from the fact I am using the local variables. Is this allowed on a Create Database statement? I haven't found anything in Technet that may help.

Here's hoping....
Thanks
Dan

View Replies !   View Related
Create Database In Local Machin
Hi,
I wanted know that how I can create database in local machine?.
Thanks,
Ravi

View Replies !   View Related
Local Database On 2005 Express
I have an internet based sql database that is being updated all the time - for sales purposes I need a local copy on my laptop which is running xp pro and 2005 express. In sql enterprise manager I can take a local snapshot using dts is there a way to do this or something similar using 2005 express - if so any help would be appreciated

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved