How To Prevent Domain Admin Users From Accessing SQL 2000 Databases?
Based on our database infrastructure, we need to secure our SQL databases. The security issue concerns on allowing a limited number of Domain Admin users to access the SQL databases.
We tried certain ways, based on the documents in the Microsoft web site, but we couldn€™t reach to the point of preventing the Domain Admin users accessing the SQL databases.
Thanks in advance.
View Complete Forum Thread with Replies
Related Forum Messages:
Accessing Multiple Databases From Stored Procedure In SQL 2000
Hi , I have around 5 databases with same structure used to store data for different locations and services. I have created an intermediate database which will have all the stored procedures to access data from above 5 databases. My queries are common to all the databases. so,I would like to pass database name as an argument to my stored proc and execure query on specified database. I tried this doing using "USE Databasename " Command. but it says ...We can not use "USE command " in stored proc or triggers. so ..what i did is .. -------------------------------------------------------------------------------------------------------------- CREATE PROCEDURE TestDB_access(@dbname varchar(100)) AS BEGIN DECLARE @localDB varchar(100) Set @LocalDB=@dbname if @LocalDB='XYZ' EXEC ('USE XYZ ') elseif @LocalDB='ABC' EXEC ('USE ABC') Select * from Mytable END --------------------------------------------------------------------------------------------------------------- When I run this from my database , it gives me an error "unable to find table "mytable". What is the best way to make my queries work with all the databases. Thanks in advance Venu Yankarla
View Replies !
How To Prevent My Co-Workers From Accessing My SQL
Hi all In our office we have simple Network (LAN) and for some reason in each workgroup Computer in this network we have installed SQL-Server 2000. So far everything was ok but recently i noticed that my co-workers can easily access my Sql Server Instance through their Enterprise manager installed on their computers and then they can open my tables,view...and manipulate other objects. for better illustration i have created a Flash Movie from this process , please check the following Link : http://www.Parsisoftco.com/movie/Sql/Sql.htm How can i prevent others from doing so? Any help greatly Appreciated. Kind Regards.
View Replies !
How Can I Prevent My Co-Workers From Accessing My SQL Instance..
Hi all In our office we have simple Network (LAN) and for some reason in each workgroup Computer in this network we have installed SQL-Server 2000. So far everything was ok but recently i noticed that my co-workers can easily access my Sql Server Instance through their Enterprise manager installed on their computers and then they can open my tables,view...and manipulate other objects. for better illustration i have created a Flash Movie from this process , please check the following Link : http://www.Parsisoftco.com/movie/Sql/Sql.htm How can i prevent others from doing so? Any help greatly Appreciated. Kind Regards.
View Replies !
Domain Admin And Sa
A couple of newbie questions: 1) Do Domain Admins have SA rights by default in SQL7? If so, is there a way to keep domain admins out of particular databases. 2) Is it possible to create a database or table that even SA can't get into? Thanks JD
View Replies !
Admin Access To SQL Without Server/domain Admin Access
We are using Win2k3 R2 with SQL 2000 in a domain environment. Is it possible to create a domain group to grant admin level and user level access to SQL2000/2005 without giving users server admin or domain admin access? It has always been my impression that to have admin access to SQL that you had to at least had admin level access on the server. Any clarification would be greatly appreciated. Thanks!
View Replies !
Permission Domain Admin
Hi , We are using SBS2000 with SQL 2000 and Terminal server . In the Terminal server ,we have an application that connect to sbs (sql) . The Problem is that User without Domain Admin permission can not modify in database. How Is it possible to grant full access to SQL2000 without giving users domain admin access? Thanks , Samuel
View Replies !
Deactivating Admin And Domain-Admins
Hello, is it possible to deactivate the groups admins and domain-admins in sql server without getting in trouble with the sql-server. For example when the system boots the program should start normally without any problems. We want do deactivate the accounts because we have some critical information in sql server and dont want to give all admins the possibility to have a look at these data. We just want to have sa within the role sysadmin. Regards Franz
View Replies !
Is It Possible To Prevent Databases From Being Copied?
Hi, We have a point of sale application (C# .NET 2.0) and a Sql Server 2005 database back end. Our customers are concerned that employees could create a backup of the SQL Server database (or even of the MDF file) and use it to steel customer data. Very often, the application is running on a single PC in a shop using Sql Server Express Edition 2005 under Windows XP. The users usually log on as local administrator. It's hard for us to force our customers to change their local security policies. Ideally, I would like some form of security mechanism that prevents a backup from being restored on to another PC without either a password or some other form of authentication. Is this possible? Regards, Sigol.
View Replies !
GRANT SELECT ON [dbo].[TblAreaCatmap] TO [admin] Prevent Grant From Being Automaticly Add To Each Column
GRANT SELECT ON [dbo].[TblAreaCatmap] TO [admin] prevent grant from being automaticly add to each column? Is there a way when you issue a grant select to a table or a view to not also grant select for each column. The problem is when you use the grant command it automaticly adds the grant command to each column. I want to grant the permission at the table level so when the table is scripted it only has a single grant command instead of a grant for the table and a grant for each column which is not needed. The sql managemnt studion interface will allow you to do this but onlt by using the interface. If you issue the above command from a query window it also creates A GRANT FOR EVERY COLUMN. How can I stop this behavior.
View Replies !
Non-Admin Users Cannot Load Reports
Originally posted this in the performance point forum, the error actually occurs if link direct to the reporting web site as well. The reports are being created in the report builder, from the web service. ----- Attempting to add a report services report into a performance point dashboard page. Everything is installed on one box. When the admin logins load the page, everything works great. When a non-admin loads the page, everything except the report generates, and the following error kicks off: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'dataSource1'. (rsErrorOpeningConnection) Login failed for user '####' The user login in question has been given browse access to everything in the report services web. I'm not sure where or how to grant whatever access is necessary for this to work properly.. and really I was hoping that any authenticated user at the dashboard level would be able to view the report so I didn't have to do security twice. Can anyone point me in the right direction?
View Replies !
Report Generation Time Between Users And Admin
Hi, When we generate a report with an account that is in the admin group it takes 2-3 seconds but when we do it with another user it takes over 2 minutes... any reason for this? (The "Report is being generated" thing, by the way) Not sure if my question is clear, I've been looking and searching for the past 2 hours but can't find anything remotly close to that problem... any help would be appreaciated! Thanks
View Replies !
.Net App Deployment Scenario: Privileges For Non-Admin Users
My VB.net application manipulates data in a local SQL Express database. When the app is installed, the database does not exist, but it cannot be created at run-time by anyone other than a user with administrator privileges. In addition, the application shares the data stored in SQL with a critical 3rd party component that can only reach the database via named DSN (also not existing prior to installation). I see my primary SQL security options as being: (1) Use SQL or Mixed Mode authentication with an admin-level username/password combination, or (2) Create a db user/group with admin-level privileges and grant membership to all NT authenticated users Secondary problem: Creating the DSN. Does it make sense to create a Custom Action (.dll) that is called at the end of the installation process in order to create the database, the user security context and the named DSN? Am I overlooking some built-in functionality provided by Visual Studio 2005 that will accompish some or all of this for me? I am aware that customizing the 'silent' installation of SQL Express to use a different authentication mode requires manifest tweaking -- I just don't know anything about setting up the appropriate security for this situation. Would you put the db and role creation stuff in a SQL script and execute it post-install? Thanks in advance for any insight you can provide. -T
View Replies !
Domain Users Rights
I have a problem that im using Active Directory in Win2k Server, when domain users logon to workstations they can't open sql server databases, SQL server is local installed on Workstation and operating system is XP. When i give administrator rights to users the sql server works fine. Tell me is there is a way to use sql server without giving to the user administrative rights? thanks
View Replies !
Migrating Users To New Domain
We are currently in the process of migrating users from a NT 4.0 domain to a win2k Domain. On some of our SQL Servers the Windows Authenticated users own objects within the database. These Windows Authenticated users also own SQL Server Job and DTS Packages. Once these Windows Authenticated users are moved over to the Windows 2000 Domain they have to qualify there database objects, they can not see their SQL Server Jobs they created and they cannot modify the DTS Packages they previously created. Is their a tool or script out there that can fix this problem of moving the Windows Authenticated users smoothly over to the new domain.
View Replies !
Failure To Authendicate Domain/users
I have several access databases in mind to migrate to SQL server. I installed MS SQL 2005 Express on my machine. I will have procedures to run with authorizations beyond that of a common user, such as database administrative work where server agent is not available, I may rely on users' log-on prompt to do some maintenance work. However, I cannot get the EXEC AS 'DomainUser' to work. The procedures can be created OK. But whenever they are called, the following message shows up: Msg 15404, Level 16, State 19, Procedure XXX, Line 0 Could not obtain information about Windows NT group/user 'DomainUser', error code 0xea. I tried to tweak with the account under which the server service is running. There are three options under built-in account: Local system, Local service, and Network Service. My understanding is that Network Service will use the log-on of the current user of the computer. I have admin right of the computer. None of the three options work. Additionally, when I specify an account (my own account), it's the same thing. The procedure xp_logininfo always fails when I query a specific domainuser. The ADHelper is configured to run manually. I could not think of other ways to get a possible solution. Any help is much appreciated.
View Replies !
SQL 7.0 / NT Domain Groups / Logins / Database Users
I’m in the process of upgrading 6.5 to 7.0 on all of my clients servers. I would like to get away from maintaining individual logins on SQL by using NT Domain groups which have been working very well on the test server. I've then mapped the group login to a role which works great most of the time, but a few users need more rights some of the time. I can’t figure away to give them individual rights with out creating a login for them, or by using this work around which would be a pain. If a user creates a table in a database (providing they are not DBO) they are automatically made a user in that database but not added to the server logins, I can then give them rights to other objects. I don’t see any other way of adding this individual user to a database that doesn’t have a login.
View Replies !
Report On Users Accessing A Database
Hi, I need a way to automatically generate a daily report of user names, time of access, and type of access (login, select, insert, update, delete, etc.) to a database. We need to audit all accesses from all accounts to find out who is accessing the payroll system. We have already defined the security to be as tight as possible - however we need to monitor all Administrator accounts to ensure they are not being used to obtain sensitive information. I have looked for some software to read the live SQL Transaction Logs, but none of the tools I have seen can do exactly what we require. For example, I've tried Lumigent Log Explorer (http://www.lumigent.com/products/le_sql.html), but it's not automated and the report output is just garble to our payroll staff. I have looked up all Microsoft SQL Server partners but their software is all about data recovery and data reporting. We need Security Reporting. I have created a general SQL Profiler trace that may suffice if everything else fails, but I still have no way of automating it - it relies on Real-Time monitoring which I can't trust (admin can turn this off, do their stuff, turn it back on). Also this is dependant on someone turning it off, save the log, turn it back on, every day - this person would be the Administrator - what admin would monitor themselves? - SQL Trace seems like a good idea, how do I read the trace log file? How do I automate a trace? - Can we automate the SQL Profiler to read the transaction log to find all accesses to a database? - Does anyone know what we can do to automatically audit accesses to a database? What format can the report come in (pdf, xls, dbf, html etc.) - Recommended software to try? - Ideas for alternatives to try? - Any companies/developers out there who know of a tool or are developing a tool to provide this sort of report? - Is there a spec somewhere to let us write our own software to query the live transaction log? Thanks, I appreciate any help. Kind Regards James Payne IT Administrator
View Replies !
Report On Users Accessing Reports
All, I would like a report to display the number of users and the reports accessed for a certain duration of time[being able to go back and check for previous years as well]. I read on the msdn that 60 days worth of report log is kept,and the rest gets wipped off.Any suggestions on how I would be able to get user access list for the past year as well.
View Replies !
Domain Users + Local Groups + Scale Out Deployment = Problem
We have a problem authenticating domain users contained in local machine user groups across multiple web servers in a scale out deployment. When we originally setup our single SSRS database server we were told the a best practice is to add domain users to local user groups on the SSRS machine. Now we want to add more web servers and create a scale-out deployment. So, we added the web servers and configured the scale-out deployment. But, only administrators can see the reports since all of our SSRS roles are assigned permissions such as "Machine1User_Group". We were told that we have to create identical local groups on Machine2 and Machine3 and then add them to the SSRS roles. This is prohibitive since it would mean managing 3 identical user groups containing thousands of domain users. Is there a better way to do this without using Domain User Groups? Thank you for any assistance.
View Replies !
Accessing Password_hash By Users In SQL Server 2005
In SQL Server 2000 we had a view that would show the user credentials and the password hash. The reason we need this is that we use SQL Server authentication on the database. To test users, we have a login with little access, and it should be able to see the view and compare the password supplied against what is in the database, and then let the code handle a graceful exit if the password is invalid. I am trying to do this with SQL Server 2005, and I am running into trouble. I am trying to do this with a function, since there I can set the EXECUTE AS clause (in theory) and leverage the privlidges of a specific user in the database. Here is an example function: CREATE FUNCTION check_acct.fn_allusers (@test int) RETURNS @users table (username varchar(50), passwd varbinary(256)) WITH EXECUTE AS caller AS BEGIN INSERT @users select name, password_hash from sys.sql_logins RETURN END GO GRANT SELECT ON fn_allusers TO user_acct I cannot get to all rows in the sys.sql_logins table unless I first: GRANT VIEW ANY DEFINITION TO CHECK_ACCT then when I call this function from CHECK_ACCT, I am able to see the data. If I change the WITH EXECUTE AS 'CHECK_ACCT' and execute thsi function from USER_ACCT, I do not get the same results. Do functions not inherit VIEW DEFINITION proivlidges? Any suggestions on how to do this but limit access to these secure objects to this one function?
View Replies !
How To Prevent Users From Logging To DB During Its &"maintenance&"
I am really a DB admin beginner, so hopefully it'll be easy for you to answer my simple question: How can I temporarily prevent users (except "sa") from logging to database(s) or better to DB Server while there are applied scripts on them ? I have already tried TCP/IP port changing, hiding server, running a single user mode but the reult was very poor. Please note that "sa" has to be able to connect to DB Server from a third party application but other users not. Any idea and/or a known solution ? Thanx in advance for your hints BTW - MS SQL 2000 SP3a
View Replies !
Accessing Windows Users Assigned To A Database Role
Is there a way to find a list of Windows User accounts that are directly or indirectly (through Windows Group membership) assigned to a database role? I could put work in to CLR programming or using a Linked Server to Active Directory, but if there is a sys.* view available that can provide me this information directly it would be much easier. I'll be looking into this further myself anyway and posting an answer if I can find one, but if anyone has suggestions... well, thanks!
View Replies !
Accessing Two Databases
Hi, I am developing a small asp.net application where I read from a readonly omnis database via odbc then dependant on user input write records to a second database.My first idea was to use an odbc connection to Omnis database and write to ms sql database. There is quite a few queries that need to be made to the Omnis database and I am binding a datagrid to the MS Sql server database. I was hoping to use stored procedures to update the mssql tables. So there will be much opening and closing of connections. Should I go down that road or should i think of using an Access database, with linked table to the Omnis database, then only one connection needs to be made. And I can store my information in the Access database tables. Thanks.
View Replies !
Accessing Two Databases At Once
I'm new to databases as you probably can tell. A friend sent me three data bases, which in my mind should have been one database with all the tables included, but he didn't. So my question is, can you pull info from two databases in the same query? I write the query acessing one database and the result chart must depend on a where predicate based on accessing tables in another database. If this isn't possible, how do I get the tables I need together, that presently reside in differing databases? Thanks for the help in advance. Milfredo
View Replies !
Accessing Users && Members In Active Directory Via Linked Server
Hi, I'm trying to extract all the users and their membership to groups, and the membership of groups to groups from active directory though a link to server. I can get the users. I can get the groups.... individually. I can't get the info of what user is a member of or who are members of a group. Anyone know how to do this or am I going to have to right a vb app? (Anyone already got the code...) I want to load this data into tables for reporting in my Data Warehouse. Cheers Chris
View Replies !
Accessing 2 Databases On The SQL Server Through ASP.net
Hi everyone, First of all I'd like to say I'm new to the forums, and in fact new to ASP.net. I've had a couple of applications running in VB.net for the last year or so that I now am looking to move on and into ASP.net (main reason is to do with implementation to remote sites in foreign countries). I'm currently following through the "Working with data and ASP.net 2.0" walkthrough on this site, which I must say has been a great help. I'll start with the background stuff first I have my main database on an SQL server. I also have 2 other databases on there - Customer and Employee. The reason for these are that they are shared amongst my VB applications and I kept them as seperate databases so that one database is all that needs to be administered and maintained, and these changes are then seen on both apps (takes away redundant data as well). In my main database, main table, is a field called CustomerID. This value relates to the CustomerID in the Customer table. In my VB app all I do is have the user select a customer name, and then the customer ID value is copied to the CustomerID field of my main table when inserting / updating a row. This is simply accomplished with 2 SQL connections and 2 dataAdapters. I also use 2 dataSets - one for Customer, one for WorkRequests (the main database)... I use ComponentOne stuff so that my grid will show the CustomerName instead of the CustomerID etc, and the same applies when I use my Employee database - I run many dataAdapters to this for things such as Account Manager, Technologist, Creator, UpdatedBy etc etc. Now, I'm new to VS 2005 - my apps were created in VS 2003 and .net 1.1. Can I easily re-create my apps in ASP.net? My primary goal at the moment is to make sure I can load a row, and display the "lookup" values instead of the "integer" value. As my tables are in seperate databases, I would like to know the best way of accomplishing this, if it is of course possible. Help and advice much appriciated. Kind Regards, Luke
View Replies !
Accessing Databases Across 6.5 Servers
Hi Everybody, I am trying to created a script in transact sql where I need to select data from multiple servers. I need to run this script from a workstation or as a stored procedure on one server. Please Help me Thanks in advance Deepa PS: please reply back to my email
View Replies !
Accessing SQL Server Databases From Networked PC
Hello all. I have just built another PC (New PC)and have it connected to myOriginal PC via a LAN. I have my SQL Server 2000 installed on the OriginalPC. Both PCs use WinXP Pro OS. I believe I now have to install the ClientTools on the New PC but after that, how do I access the SQL Server that ison the Original PC. The SQL Server is setup with mixed (both WindowsAuthentication and SQL Server Authentication). Just how do I use the SQLQuery Analyzer that I just installed on the New PC to connect to andretreive data from the SQL Databases which are on the Original PC? Thanksin advance for any help, Jim.
View Replies !
Error When Accessing Sample Databases
Hey, Everyone - I have downloaded two of the sample databases and get the following error when I attempt to open them: Unable to open the physical file "c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAAssets_Maintenance_log.ldf". Operating system error 2: "2(The system cannot find the file specified.)". (Microsoft SQL Server, Error: 5120) So what am I doing wrong? The install of these sample databases is simple and straight-forward. Thansk! Regards, Bob Mitchell
View Replies !
Transaction Support Across Tasks Accessing Two Different Databases
I am trying to determine if it is possible to add transaction support for a SSIS package. Here are the basic tasks: Read New/Updated records from SQL Server Update changed records in Access Insert new records into Access Update new records in SQL Server with Access key assigned on insert in previous step Reset dirty_flag I would like to wrap a transaction around this. If the package fails in the task that updates sql server with the Access key, the next time it runs, it duplicates the new records in Access because it did not finish the process. Is it possible to have a transaction wrap this entire process so I can undo the inserts to Access if I fail any subsequent tasks? Thanks, Steve
View Replies !
How To Restrict Users To Particular Databases
While web hosting I use Sql Server 2000 as the database. Imagine I have hosted 3 Web Sites. All these 3 users want to modify/update their designs. What I did is I created respective 3 users having access to the respective databases only. So that they can registerd the ip and add to the Sql Server 2000 Enterprise Manager. These users are able to access their own databases only. But all these 3 users are able to access the default databases like master,pubs etc. How to restrict this. Also suggest which is the optimal way to give control to the respective users while using Sql Server 2000. ====Suresh, P.R, Postal Training Centre, Mysore.
View Replies !
Users And Logins Across Databases
hi, In sql2k you used to be able to have a same user in 2 databases under the same login. Just moved to 2005, using sql authentication, and have some users who need to access 2 databases using the same login credentials. But sql2005 will not let me create 2 users under the same login across databases. Any ideas? Thanks, Mat
View Replies !
Performances In SqlExpress 2005 When Accessing Multiples Databases
Hello, I've written this stored proc, which have to collect records in one table in several databases. These tables contains very few records (1 to 10 max). In SQL Server standard edition, this stored proc is executed instantaneously. But in the Express, it could take 1 minute. Is there a solution to this problem ? Thanks in advance, Best regards, Guy ALTER procedure [dbo].[SP_CHECK_USERS] AS select 'FIDUCIAIRE' as code,moment,nom,machine from MERCATORFIDUCIAIRE.dbo.sessions s1 where (s1.inactif=0) and (s1.nom<>'MercatorIshop') union select 'TEST1 ' as code,moment,nom,machine from MERCATORTEST1.dbo.sessions s2 where (s2.inactif=0) and (s2.nom<>'MercatorIshop') union select 'TEST10 ' as code,moment,nom,machine from MERCATORTEST10.dbo.sessions s3 where (s3.inactif=0) and (s3.nom<>'MercatorIshop') union select 'TEST11 ' as code,moment,nom,machine from MERCATORTEST11.dbo.sessions s4 where (s4.inactif=0) and (s4.nom<>'MercatorIshop') union select 'TEST12 ' as code,moment,nom,machine from MERCATORTEST12.dbo.sessions s5 where (s5.inactif=0) and (s5.nom<>'MercatorIshop') union select 'TEST13 ' as code,moment,nom,machine from MERCATORTEST13.dbo.sessions s6 where (s6.inactif=0) and (s6.nom<>'MercatorIshop') union select 'TEST14 ' as code,moment,nom,machine from MERCATORTEST14.dbo.sessions s7 where (s7.inactif=0) and (s7.nom<>'MercatorIshop') union select 'TEST15 ' as code,moment,nom,machine from MERCATORTEST15.dbo.sessions s8 where (s8.inactif=0) and (s8.nom<>'MercatorIshop') union select 'TEST16 ' as code,moment,nom,machine from MERCATORTEST16.dbo.sessions s9 where (s9.inactif=0) and (s9.nom<>'MercatorIshop') union select 'TEST17 ' as code,moment,nom,machine from MERCATORTEST17.dbo.sessions s10 where (s10.inactif=0) and (s10.nom<>'MercatorIshop') union select 'TEST18 ' as code,moment,nom,machine from MERCATORTEST18.dbo.sessions s11 where (s11.inactif=0) and (s11.nom<>'MercatorIshop') union select 'TEST2 ' as code,moment,nom,machine from MERCATORTEST2.dbo.sessions s12 where (s12.inactif=0) and (s12.nom<>'MercatorIshop') union select 'TEST20 ' as code,moment,nom,machine from MERCATORTEST20.dbo.sessions s13 where (s13.inactif=0) and (s13.nom<>'MercatorIshop') union select 'TEST21 ' as code,moment,nom,machine from MERCATORTEST21.dbo.sessions s14 where (s14.inactif=0) and (s14.nom<>'MercatorIshop') union select 'TEST23 ' as code,moment,nom,machine from MERCATORTEST23.dbo.sessions s15 where (s15.inactif=0) and (s15.nom<>'MercatorIshop') union select 'TEST3 ' as code,moment,nom,machine from MERCATORTEST3.dbo.sessions s16 where (s16.inactif=0) and (s16.nom<>'MercatorIshop') union select 'TEST4 ' as code,moment,nom,machine from MERCATORTEST4.dbo.sessions s17 where (s17.inactif=0) and (s17.nom<>'MercatorIshop') union select 'TEST5 ' as code,moment,nom,machine from MERCATORTEST5.dbo.sessions s18 where (s18.inactif=0) and (s18.nom<>'MercatorIshop') union select 'TEST6 ' as code,moment,nom,machine from MERCATORTEST6.dbo.sessions s19 where (s19.inactif=0) and (s19.nom<>'MercatorIshop') union select 'TEST7 ' as code,moment,nom,machine from MERCATORTEST7.dbo.sessions s20 where (s20.inactif=0) and (s20.nom<>'MercatorIshop') union select 'TEST8 ' as code,moment,nom,machine from MERCATORTEST8.dbo.sessions s21 where (s21.inactif=0) and (s21.nom<>'MercatorIshop') union select 'TEST9 ' as code,moment,nom,machine from MERCATORTEST9.dbo.sessions s22 where (s22.inactif=0) and (s22.nom<>'MercatorIshop')
View Replies !
Accessing SQL Mobile Databases In VB2005 - Pocket PCApp
I am using VS 2005 to develop a Pocket PC 2003 application and for some reason I dont have the ability to assign my datasource to a SQL Mobile Database? When opening Server Explorer, right clicking Data Connection, Add New Data Source, Change Data Source, the only options I get are Microsoft Access Database File Microsoft ODBC Data Source Microsoft SQL Server Microsoft SQL Server Database File Oracle Database <other> I was trying to follow the tutorial Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005 (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp) and in that tutorial when they do the exact same thing it shows a screen shot that also lists 'Microsoft SQL Server Mobile Edition' Any ideas why I dont have that option? FYI, I have SQL Server 2005 and have installed SQL Server 2005 Mobile Edition. Thanks Mike
View Replies !
How Do I Write SQL Query Accessing Multiple Databases (DBFs)?
I have several database files, all in the same directory. I want to write SQL statements that access two databases at once. For example, if only one database would be involved, I would write: SELECT Test_Source_ID_column, Data_column INTO Test_Destination_table FROM Test_Sources_table The above query copies two columns (Test_Source_ID_column and Data_column) from Test_Sources_table into a brand new table called Test_Destination_table. Now the above query is fine for both the old and new tables being in the same database. But what if Test_Sources_table is in file Old.dbf and I want the new table Test_Destination_table to be in New.dbf? Both Old.dbf and New.dbf are in the same directory. Therefore, there is no security issue about using ......etcpasswords. I should therefore be able to use relative paths. So, I also want to know how I can do that select on two databases in the same directory without typing long, long paths. Is there a way to do queries that access multiple database files (all database files being in the exact same directory) AND use relative paths or no paths (and certainly not type a full path)? NOTE 1: I'm using SQLEXPRESS, therefore do not have the SQL Server 2005 tools. I have Visual Studio 2005 Developer Edition with its tools. NOTE 2: One table is accessed through ODBC. The other table is accessed through SQLEXPRESS.
View Replies !
|
TRACKER
