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 Replies


ADVERTISEMENT

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

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

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

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

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

Error When Transferring Data From Local Database To Hosted Database

Hi,

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







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