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?
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 i put the service properties to Automatic or Manual i am getting the error message that is saying that the service is disabled cannot start automatically.
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?
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.
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
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?
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?
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 - !  SQLServer Error: 6, Specified SQL server not found. [SQLSTATE 08001] 2007-01-02 16:34:41 - !  SQLServer Error: 11004, ConnectionOpen (Connect()). [SQLSTATE 01000] 2007-01-02 16:34:41 - !  Unable to connect to server '(local)'; SQLServerAgent cannot start 2007-01-02 16:34:42 - ?  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.
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?
Hi, I've installed SQL Server 2005 Express Edition, SQL Server Management Studio Express using Windows Authentification and IIS 5. The problem occurs when 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 my settings for Windows Authentification or?
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?
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.
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?
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.
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
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 or do I need another layer which will update from a table for example??
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.
I am trying to use the Import Wizard to setup a daily job to import new records based on an ID 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 getting an 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 to verify new records?
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...
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
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?
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 ?
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?
Scenario: In general user 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 informing each record status to the user. ex: record 1 updated / call closed do you want to update?
Here local database is going to be Pocket pc database 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.
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..
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?
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.
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.  Lock Blocks,  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'.