Can I write a select statement which will querry from two different machines.
such as select mach1.db1.dbowner.table1.column1, mach2.db2.dbowner.table1.column1 from mach1.db1.dbowner.table1, mach2.dbowner.table2
How can I copy a SQL 7 database from one server to another? Please tell me all the ways because I've tried the obvious and it doesn't work. (backup and restore - won't go from one server to another, DTS transfer object Wizard - does a whole pile of errors and doesn't do stored proceedures and trigures). Thanks for help in advance. Also, what is the email address to post to the listserv and where is the FAQ for SQL7? Most of my listserv's tell you where to post right at the bottom of the digest I get - any chance you guys would do that with this list? Thanks again.
View 6 Replies View RelatedQuestion - is there anyone out there running SQL Server on machines in the 2GB-4GB of RAM Range who has quick sec for a ? The documentation I have found for running SQL Server(native 32bit 2 GB RAM max) on 2GB+ machines is a little confusing (to me) if anyone can answer my question that would be great. I am running Ent SQL Server on WIN2K Adv box with 8 Xeons and 4 GB of RAM. I have enabled the /3GB switch in the boot.ini file but have not enabled AWE memory management in SQL. I have set the MAX amount of RAM avialble to my SQL box at 3GB and SQL Serve appears to be using all of the 3 GB under load. Is this the right way to set this or is there another more efficient way? Any answer explenations would be great. Thanks in advance
PS The server is only a SQL box no other apps / servers are running it.
Windows Server 2003
SQL Server 2005 Enterprise SP2
The mirroring wizard insists I enter a fully qualitifeid domain name for my servers. But my servers are not on a domain - I just address them as machinenameinstancename, which the wizard convertrs to TCP://machinename:5022. When I click Start Mirroring it tells me that this is not a FQDN, which is true. How do I make this work?
Cheers,
Mike
SQL server 2005 developer version
I have about a dozen db's scattered on 3 machines and want to
consolidate all of them on my desktop with the data intact.
What's the easiest, best way to accomplish this?
Can I backup on one and restore on another?
Hi All,
I have got MSSQL 2000 set up on a machine in my rack at my local telehouse, and a web server set up at home on an ADSL line.
Both servers can see (ping) eachother fine , so you can rule out any kind of connectivity issues straight away, but when i try to get my forum to connect to the mssql database using the correct credentials it just fails saying that the credentials are incorrect ot the server does not exist.
I also installed an SQL database tool on my web server (Shusheng SQL Tool) and attempted to connect to my SQL server using that tool, and got the following message: '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.'
The server is currently using mixed mode authentication (SQL/Windows) and has both TCP/IP and Named pipes enabled.
Is there some kind of 'Enable remote connections' option in SQL? I need to be able to allow connections to my SQL server from any system, anywhere...
Any ideas?
Good morning,
I am looking for some first-hand experiences from fellow DBA's where they had SQL Server running on a Win2K3 VM. What sort of issues (or successes) did you find re: resource sharing, swap files, etc? Are there any experiences where using a VM negatively affected your environment?
Thanks so much. What a great forum!
Hi,
I'm an SQL Server novice.
After developing some websites (VS 2005 VWD), my machine started to crumble. (e.g, SQL Server won't uninstall and lots of other software problems)
So I bought a new machine and set up a clean installation of SQL Server 2005 Standard and Visual Studio 2005 standard.
I copied my old "projects" folder to the new machine but I cannot use it.
1: When I try to import I get a "cannot import external files" error.
2: When I click on a project, it launches VS 2005 and I can edit etc.
However, when I try to run the website in VS 2005, I get the following error.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) an error
Please can someone let me know how I can get my "old" projects running in my new environment?
Thanks
Ken
Hi,
I'm in the process of designing a system which will have a central internet based SQL Server database, and one or more clients running SQL CE.
If there is more than one client machine running the same software, is it possible to have all these clients use a central SQL CE db on one of the clients? In other words can other machines access a SQL CE running on say a "master" machine? These machines my be in a workgroup or on a domain by the way.
I know I could use a SQL Express db on the master machine, but I'm keen to use SQL CE because of the Sync services dlls that came with VS 2008 (which I believe only work in CE).
Thanks,
Russ
I have a server with a sqlexpress database on it.
It has 'Allow Remote Connections' checked
It has the Browser Service enabled and started utilizing Surface Area Configuration
It has Local and Remote Connections Using both TCP/IP and named Pipes.
I have used http://support.microsoft.com/kb/914277
And one machine can connect to it fine.. .
but others can't?
Any Ideas?
Casey
Hi Guys!
I'm trying to find a way to either importexport or synchronise an SQL 2005 db between a local and remote server, is there any way to do this programatically or otherwise? doesn't have to be the entire db, (like just aspnet_users and related tables will do)
Thanks for the help all!
I am trying to copy DTS Packages and Jobs from two different Servers to one new server. I know I can script the jobs, but they won't run without the DTS packages. I have backed up and restored the MSDB database from Server 1 to my Main server and therefore I have all the jobs from that machine. My problem is how do I get the jobs stored in SERVER 2's MSDB over to my main server without replacing the tables I already have thus losing the jobs and packages that I imported? I have thought about backing up Server 2's MSDB then importing to another database,on the MAIN SERVER and then importing with an append to the 'live" msdb, but I believe the table names are the same and I may end up with duplicate entires. I don't know what problem this will cause. Any suggestions will be great. Thanks in advance
View 1 Replies View RelatedHi all. I'm having a strange problem occur - any help would be appreciated. I have a data driven query task that is a part of a much larger package that runs fine and completes successfully if I run it by right-clicking on it and running an 'execute task' on just that individual task. This completes successfully only when I run it from my local machine with the SQL 2000 box registered on it. The task does not complete - or at least runs for as long as I'm willing to wait - if I run it either as part of the entire package or alone, as described above, directly on the SQL 2000(running Win 2000 Advanced). Obviously this is not good because the larger overall package is an integral part of a nightly cycle. Any thoughts?????
View 1 Replies View RelatedI'm specifically referring to 2008 R2, and TomCat in particular (not sure of the *Nix variant involved), where I was asked if there were any configuration settings on the database side (meaning SQL Server) that can be viewed to show how long a connection to the server, once idle, will last, before it is forcibly closed. I when Googling, but as I'm not very knowledgeable on that topic, I'm not really sure what I'm looking for, and the only results I came across didn't identify what I'm looking for. Of course, it may be that such a config setting doesn't exist, but it would be useful to know how such things are handled.
View 0 Replies View RelatedHi,
How do I get a list of sql server 2005 machines from the network please?
Thanks
I need to move our production database to a brand new machine on our LAN.Both machines are running SQL2K. I'd like to place the production databasein a directory on the destination machine with a slightly different pathname than the source SQL server.How can I shrink the transaction log to the minimum size before I try themove? What is the best way to move the database to the new machine? Wehave Veritus Backup Exec.Regards,Charles MacLean
View 1 Replies View RelatedWhat is a good simple way to scan the servers in your network for SQLServers?Does anyone have any scripts or code that would show me how to dothis?I think WMI might be able to do this but don't know where to start.If possible I'd like to be able to get the version (2000 or 2005) ifpossible.Thanks,Kelly GreerJoin Bytes!change nospam to yahoo
View 1 Replies View RelatedHI,
I've got the folloing scenario:
Client app is a windows forms app on client machine. Web Service on a dev machine (Windows 2003 standard), SQL Server 2000 on a seperate machine. The user logs on to the using their windows login. I'd like to pass these credentials to the web service, have the web service impersonate the user and access the SQL Server with these credentials... not a problem I thought.
Setup windows integrated login on IIS for the web service, impersonate="true" in the web.config, Mixed mode on the SQL server. Passed the network credentials through to the Web Service, and this works correctly, however when the web service (impersonating the user) tries to access the SQL Server, I get the message about access denied, user is null, blah, blah. (if remote access the Web Service box, and call the web service locally, all works well, and voila, until the thread recycles, the client machine access also works... same user/pass)..
I've seen various posts about this but nothing seems to solve the problem. Am I right in thinking that this method (Windows integrated login) of passing credentials through to the SQL Server is the best method? If so... er, shouldn't it work? What am I doing wrong here? and if it doesn't work, what other method would work?
I've just about given up on this and thinking of passing the SQL Server Username/Password across the network (shudder), encrypted yes, but not ideal!
Anyone got any idea?
Regards
Kevin
Hi,
My Reportserver Homepage is http://d620xp/Reports
Requirement is that Users should be able to view all the reports from this URL( from their Desktops)
What are the steps I need to do, to get this ?
Thanks in Advance,
Sundar
I have an SQL2012instance running.
I create a sql user who is part of sysadmin, securityadmin, setupadmin and serveradmin roles.
When I try to connect through odbc using this user from other machines, it works fine. But if I remove it from sysadmin, I get an error message Connection Failed:
SQLState : '28000'
SQL Server Error: 18456
[Microsoft][SQL Server Native Client 11.0][SQL Server][Login Failed for user:user1]
Hello,
I have to find out whether my servers have hyperthreading enabled or not???? I am running Windows server 2003 Standard edition on many of my machines. I have to configure the SQL Server, server configuration values according to the Hyperthreading. I know about the CPUcount.exe utility but is there anything else apart from it??????
Hi,
Can I access from App machine (on WinXP) to SQL 2005 Exp machine (on WinXP) ?
I installed SQL 2005 Exp SP2 on Win XP SP2 on my PC. Please consider following environment:
- My PC name: MyPC
- Database name : MyData
- Database role for MyData without any permissions: MyDBRole
- Application role for MyData having all permisions: MyAppRole
- Database user: MyDBUser
- SQL Login: MyLogin (WinXP Limited Login) mapped to MyDBUser
- Application Name to access MyData: MyApp
- Using Application Role MyRole in MyApp
I am accessing data from MyApp within MyLogin. When I want to access from other tool like Management Studio Express, I can not access it and that that is what I want.
Till now it is OK when I am doing all these things on MyPC.
Now question is : Is it possible to connect from other PC (say CleintPC) running Windows XP SP2 use MyApp ?
I think ClientPC should access MyPC through MyPC's MyLogin.
[ I have tried successful simple SQL server connection with MyPC's Guest Login]
Please tell me is it possible ? (Running SQL Express on one machine, Application on second machine and both machine's operationg system is Windows XP)
Thanks
I need to synchronize the data from one server to another every night...
There is a server called A and B need to do something to sychronize ? I know this concept as repliction but there are more than 1500 tables and finding out from 22,000 and publishing is hell, is there any other way which i can do and could anyone help me breif me to do this.
Thanks a lot for ur help
Hi,
I read in oneof the articles somewhere that users can also download cubes to their local machines for off-line browsing/analysis. This can be very useful if the user is suppose away from the office or not connected to the LAN.
I wanted to request if someone can explain the process of how users can do this i.e. download/save a copy of the cube to their local machines?
Thanks.
For security reasons customer wants to put a SQL database on an encrypted thumb drive (IronKey). Here's the rub though. He wants to be able to work with the data on a workstation. Then, if he takes his laptop out of the office he wants to be able to simply plug that thumb drive into the laptop and fire up SQL on the laptop and use that same database. Procedurally this would work in that the database can be created so that the location is the same from both machine viewpoints, however will the two different SQL instances allow moving the database back and forth like this?
View 9 Replies View RelatedI have an SQL2012instance running.
I create a sql user who is part of sysadmin, securityadmin, setupadmin and serveradmin roles.
When I try to connect through odbc using this user from other machines, it works fine. But if I remove it from sysadmin, I get an error message
Connection Failed:
SQLState : '28000'
SQL Server Error: 18456
[Microsoft][SQL Server Native Client 11.0][SQL Server][Login Failed for user:user1]
I am currently running a windows 2000 machine with asp, sql server,mail server, ftp server etc all on the same box.The site runs several hundred ecommerce stores. Recently theprocessor utilization has been spiking and I have decided to getanother server and use sql server on one and asp on the other.So now I have a new windows 2003 server that I have setup all of theasp code on. Problem is that when I run the asp code from the newwindows 2003 server it is extremely slow compared to the code runningon the old windows 2000 server which is where the sql server databaseis also located.From everything I have read the best way to optimize your site is touse 2 separate servers one for iis/asp and one for sql server.Am I doing something wrong here or is this normal??Could this possibly be just because the old server is still servingmany requests and is pushing the requests from the new server to theback of the line?Does anyone have any ideas?The syntax I am using to open the connection string is:db_ConnectionString = "Driver=" & db_Driver & ";Server=" & db_Server &";UID=" & db_UIN & ";PWD=" & db_pwd & ";Database=" & db_Database & ";"conn_store.Open db_ConnectionStringwhere db_server is the ip address of the windows 2000 serverIs there a better way to do it across a network??Any help or ideas would be much appreciated.
View 3 Replies View RelatedNew sql2005 install as a named instance and having trouble connecting from remote machines.
I noticed on our other servers that the "Public" server role is listed in permissions (right-click over the sqlmgr connection for the dialog, then permissions).
When I try to add the role to the new server it doesn't save! This is the only setting that's different, can't connect using sqlmgr from other machines to this server so any ideas on other settings to look at appreciated.
Hi folks,
I am exploring various solutions to setting up a scalable database configuration. To do a proof of concept, I need to setup the database in such a way that the data is partitioned on 2 physical machines.
I looked at distributed partitioned views, which allowed me to create a table on databases residing on two different servers, and then I created distributed view (with appropriate range constraints) that supported distributed selects, joins, updates, and inserts. This seemed to be the solution we were looking for.
However, I ran into a major problem because of the fact that distributed partitioned views don't allow a table to maintain an Identity column with an identity seed.
I did more research and found the Partitioned Table concept that was introduced in SQL 2005. This partitioned table allows us to have a single table which is horizontally partitioned across multiple file groups. This table now is just like a regular table in that it supports the identity column and identity seeds and guarantees index integrity. We were successful in implementing the partitioned table on a single machine, with three filegroups.
Now I need to move these file groups to different physical machines. I have found some articles on adding file group on additional hard disks on the same machine - but nothing to setup a database that is comprised of multiple servers that each handle a part of the data partition.
Is it possible to create a database comprise of filegroups residing on different physical machines?
Thanks.
Hello,
I have deployed a vb.net application to a few laptops that holds the SQL Express database as a local datastore. What is the best way to compress or shrink the database and log files? I would like a way that this can be done automatically or unattended if possible...
Thanks in advance.
I'm working on a C# 2008 project, when i add a CE Database to it, then publish the app, the installer wants to download and install the entire SQL Server Express product on the client machines. My understanding is that I should be able to embed this database right into the app, but it defeats the purpose to have the installer download and install the entire express product (the actual project is 1 meg).
Is this expected behavior? or am I doing something wrong?
Identical packages are running on 5 different machines (for load
balancing reasons). Most of the time, this parallelism is desired.
However, for certain packages, there is a need to serialize task
execution across all machines, but I'm not sure how to do so reliably.
For example,
1. Package A starts on machine 1, gets "cross machine package token" in
a "wait for token task" and proceeds, and whether it succeeds, fails, or
dumps core, releases the token.
2. Package A starts on machine 2 at ~ same time, sees the token is not
available, and waits until the token is available in a "wait for token
task".
Perhaps a "RetainSameConnection" solution using a db lock?
Hi,
Have compiled and set up a custom security extension for SQL Reporting Services on my local machine and got it working. However, I'm trying to copy the extension across to a different server. So far, I've tried copying the updated dlls straight from my machine to the server and making the relevant changes in Reporting Services .config files (rsWebApplication.config, rssvrpolicy.config, etc)
Initially, the Forms authentication redirects to a login page as expected. However, when we try to submit a login name and password from this login page, it throws this error message:
"Invalid URI: The format of the URI could not be determined."
Is copying the dlls straight across a bad idea?
If anyone has encountered a similar issue, do you know if there are there certain things I should be checking for, or have missed, when trying to replicate a custom security extension on a different machine?
(FYI, the original server where it worked was Windows XP SP2, new server is Windows Server 2003 SP1)