Hello!
My login is dbo for a database located at a remote server(SQL server7.0).Can I run the stored procedures of that database by accessing remotely.Also I have to manage that database from here,what limitations that I will have if I am not an SA for that server?Any help is appreciated.I am operating from NT workstation4.0.
One of my clients is upgrading to Sql 2000. I currently administer her server using a SQL 7 interface but I will need to upgrade that interface to sql 8 now to be able to give her the same level of support. How do I go about installing the required clients on my desktop in such a way as to not interfere with my own installation of MSDE?
I use Windows NT workstation 4. If I have a choice do I install developer's edition of SQL2000 or personal edition?
We also have pcanywhere access but this is too slow and unsure for my money.
Thank you,
Bo Graham
Hi,
I have installed an ASP.NET 2.0 application which uses a SQL Server Express database file on a client's network. I am able to connect to my client's network remotely over the internet. I would like to know if there's a way - and if so, how - to manage the Database file remotely.
I have VWD Express, SQL Server Manager Studio Express and a trial version of SQL Server 2005 on my development machine.
Thanks very much.
Regards
Gary
Hai All
How to insert and delete records from a table in the remote database?"
I want it to be done through a tool that used LDAP Servers.
I want tools for the LDAP .
Thank u Advance
Regards
Sunil
aboutknowledge@gmail.com
As a Sys Admin, I was wondering - if I have admin rights to a Win2k machinethat is hosting SQL Server 2000, do I have the ability using anycommand-line tools such as OSQL or ISQL to add, delete, or change accountsregistered in SQL Server for the various databases if I don't have access toa specific account within SQL Server?I ask, because the question that came up was - what if we have a DBA leaveunder less than amicable circumstances? Could I, someone who has adminrights on the machine, be able to log into that machine remotely and somehowvia command line (I don't maintain active SQL clients centrally), change theSA password, remove an account, and/or add an account with sysadmin rights,etc?Thanks in advance for any help -
View 3 Replies View RelatedI am not able to connect my local SQL Server Management Studio to a remote server hosting our Integration Services. I get the infamous "Access Denied". I have walked through Kirk Haselden's howto at:
http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx
but the problem persists.
Thanks for any help.
Keehan
I am trying to get my hosting company to provide a way to make secure encrypted connections from my desktop (where I am using Enterprise Manager and Aqua Data Studio) to their shared MS SQL Server.
I've seen some references to SSH, but I don't understand how this works or how the host would implement it. I also read that an SSL certificate can be installed on SQL Server, but it doesn't seem as if EM or ADS can make SSL connections to SQL Server. (In case it makes any difference for either of these solutions, the hosting company has port 1433 open, and will not close it because some clients connect to the DB server from web apps on their own intranets.)
Finally, if a web-based admin is used instead (like phpMyAdmin for MySQL), then which machine is the software installed on? Can it be on a web server that makes a local connection to the DB server or does it have to be on the DB machine? E.g., if I had a VPS or dedicated server at the same hosting company would I be able to install web-based admin software which would then connect to the host's shared SQL Server?
Anyway, my host is giving incomprehensible (to me) objections to all of these ideas. Is there a reasonably simple way to do this on a shared DB server?
How does one access a remote SQL Server from the web browser?
Thanks,
-Conrad
Dear All,
I am trying to connect to a remote sql server 2005. So I have install the Microsoft SQL Server Management Studio Express. When I try to connect I get the error below.
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53). Can some one please help. I have even port no 1533 on my pc. Thanks.
Can I connect to remote SQL 2005 server through SQL Server Management Studio Express? I always get a error code 18456 when I try to connect to SQL 2005 server through SQL Server Management Studio Express. I'm sure I enter correct username and password!
View 3 Replies View RelatedIs it possible to run both Sql Server Management Studio: Express and full blown side by side?
I am developing with the full blown product but would like to test Management Studio Express on the same box.
Is this possible?
Thanks
Eric
I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.
- When I disable "allow remote connections to this server" from server properties>connection page, I can still remotely connect to the server from SSMS...so what is the impact of enable/disabling it?
- what is the impact of changing the remote query timeout (on the same page) from default value?
Fellow Devs,
I have an instance of SQL Server Express 2005 running on another box and I have Remote Connections enabled over both TCP/IP and Named Pipes, but on my other box I keep getting the error that the server does not accept Remote Connections.
Any ideas why this might be happening? Is there some other configuration?
HiI'm going insane.I have a club starter kit on my local server which is working fine.I have migrated the database to my remote host and seems to have transfered ok.For a brief period I was able to connect to the database remotely, but now I cannot I get the following, even though SQL Server Surface Area Config is set to accept remote connections.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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)This is my connection string;<add name="ClubSiteDB" connectionString="Data Source=xx.xxx.xx.xx,xxxx; Network Library=DBMSSOCN; Initial Catalog=tets; User ID=sqladminbob;Password=sqlbob4398;" providerName="System.Data.SqlClient="/>I hav also tried to use aspnet_regsql.exe to add the remote provider but I get the same message. Thanks
View 3 Replies View RelatedI am trying to add a linked server from a AMD x64 server (Windows 2003) with SQL Server 2005 64 bit to a Server running SQL 2000. These are not in the same domain.
I can create a linked server using the option "Be made using the login's current security context" but can not when trying to specify the security context, i.e. sa and the sa password. When I try I get the following message:
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote server 'DTS_FSERVER'.
I have several other x64 server that I have no problem creating a linked server and specifying sa and the sa password.
The problem with using "the login's current security context" option is that I get an error when trying to run any Jobs against the linked server. The job fails withe the following error:
Executed as user: NT AUTHORITYSYSTEM. Access to the remote server is denied because no login-mapping exists. [SQLSTATE 42000] (Error 7416). The step failed.
I'm sure the two errors are related. Any ideas what is going on?
I just want to find out what the difference between a remote login and a remote query is. I'd have thought that a remote query inherently requires a remote login.
View 6 Replies View Related
Has anyone seen this error? It comes up when my app executes a select statement via linked server (from MSSQL 2000 to 2005) the second time it runs. It's basically a timed poll of tables in the remote database. It works once but the second time it executes I get the error from the remote db, it's just a select but I guess the cursor is still open so it can't run again. After the exception the select will run again, once and it just repeats. I have researched it a little and it looks like it mostly has to do with the isolation level of the transaction. Unfortunately based on the componet being used to access the database I don't beleive I have the ability to use transact SQL to call the isolation level (s) listed.
Here's the weird part though, at another site the same scenario is running fine. Same primary and remote db versions of MSSQL as well as the application and it runs fine. I guess my question is what type of setup parameters that may be defined in MSSQL 2005 for the remote database might make it behave in this manner in one instance and not the other? TIA in advance for any thoughts/assistance.
DT
dont know y, but i have prob. installing MS Management studio....After a hard drive failure I was forced to reinstall everything... :( The problem is that after installing vs2005 proffesional edition I installed the sql server 2005 trial edition and everything was fine during the installation.When I looked for the Management studio it wasnt there for me :( I uninstalled and reinstalled trying the full installation but results was the same, no Management studio!!!After uninstalling the SQL server trial edition I installed the Management studio express and it works. except that from some reason I cannot browse my XP user folder which has no password protection.. :( Any idea for installing the SQL trial edition including the Management studio ???Why can't I browse my XP folder with Management studio express ???Where can I download Management studio (non express version)?? regards
View 2 Replies View RelatedI have to read 25 usernames from a single users row
than display to that user the 25 profiles.
I assume this is possible with a subquery right?
Now do i have to make 25 columns 1 for each username or
could it read user1 user2 user3 ? and how please.. Thanks much
I have looked everywhere I can think of for the answer to this and am completely confused. My IT dept created an SQL database for me on a server. My plan is to create web pages in asp.net using Visual Web Dev Express released this week. I have connected to the database but I can't figure out how I am supposed to create my tables in the database. What simple/obvious thing am I missing here? I keep trying to download SQL Server Express in hopes that I can use that to manage my database but it keeps telling me that it won't install because I have previous Beta versions left on my machine. I can't find those either so am out of luck. I am new to this so perhaps I am asking all the wrong questions.Does anyone know what I can do to find a useful database management tool that will allow me to add/create the tables?Thanks for any help!
View 2 Replies View RelatedApologies if this has been covered elsewhere, but can anyone give me a insight how you manage servers in Enterprise Manager on the MMC effectively?
It seems that there is no refresh facility on the SPID view functions, and it appears impossible to monitor what is actually going on on a real-time basis. SPIDs can appear and disappear, but without refreshing the whole server and drilling down to the right area each time there appears to be no update on the activity on that server.
I have been able to zoom no-existant SPIDs - and SPIDs I have set up running massive queries persisantly show 'sleeping' unless the whole server is refreshed.
I was less than impressed with the 6.5 version for getting important information on what users were up to quickly, but this appears even worse. I wrote a beefed up version of sp_who2 for 6.5, and on Friday started looking at a version for SQL7 - I was that disconsolate!
If there is someone out there who can effectively manage SPID activity on a server using the Enterprise Manage, please tell me how you do it...
What exactly `Stress Management` is.
Any tools for assessing Stress Management?
Can anyone shed more light on the following in SQL 2K
1. Peg lookup tables in memory so that they dont get swapped out
2. Mark tables as readonly (force all queries against it not to issue shared locks)
3. Peg frequently used procedures in memory
A kick in the right direction will be sincerely appreciated
Thanks
Liju
2 more questions
1. How can I move logins from one machine to another?
2. How can I move DTS packages from one machine to another?
Thanks
Liju
Hi
I am moving towards managing sqlserver databases and i basically come from a command line background.
Can you please tell me some of the tasks that needs to be done using command line only in sqlserver and wherein management studio falls short.
regards
db2hrishy
Hi,
I'm new to MS SQL and would like to get your opinion on how it's possible to automatically manage transaction log growth. I've read the following on the topic:
"When Microsoft SQL Server finishes backing up the transaction log, it truncates the inactive portion of the transaction log. This frees up space on the transaction log. SQL Server can reuse this truncated space instead of causing the transaction log to continuously grow and consume more space. The active portion of the transaction log contains transactions that are still running and have not completed yet."
I'm backing up the transaction logs on a daily basis. Still one of the logs grew up to 130Gb even though I have shrunk it in the past. How can I manage the growth automatically without shrinking the log files manually every time they grow beyond a certain threshold?
Thanks in advance,
Alla
Hi,
I'm new to MS SQL and would like to get your opinion on how it's possible to automatically manage transaction log growth. I've read the following on the topic:
"When Microsoft SQL Server finishes backing up the transaction log, it truncates the inactive portion of the transaction log. This frees up space on the transaction log. SQL Server can reuse this truncated space instead of causing the transaction log to continuously grow and consume more space. The active portion of the transaction log contains transactions that are still running and have not completed yet."
I'm backing up the transaction logs on a daily basis. I believe that all or most of the portions of the log are inactive by the time the backup starts. Still one of the logs grew up to 130Gb even though I have shrunk it in the past. How can I manage the growth automatically without shrinking the log files manually every time they grow beyond a certain threshold? Also, how can I check whether some of the log portions are active or inactive?
Thanks in advance,
Alla
VS.NET Professional doesn't let you manage/edit database objects in SQL Server 2000 like Enterprise, but it does in MSDE2000.
Is there a tweak that will let me do this?
I am running management studio from my desktop but I think I need sp2 is there a sp2 download for management studio that isnt management studio express?
View 2 Replies View RelatedHi,
I need support for the following problem.
It is a teamwork.Suppose 25 databse developer developing a databse.every one make modification (update,delete,insert)to the centralized database.I want that every one its on database copy and make modification to that instead to centerlized database.As source control softwares do(e.g visual source safe).or any other way to manage database in such senerio.
Hope any one will help.
Thanx in advance.
I like some of the new features in sql2005 management studio, but WHY do you have to right-click -> Modify to view the stored procedure code?
It is SO annoying, previous versions was a simple and quick-double click.
To me this is a major blunder!
Anyone else agree with me?
Hello,
I am hoping some of you can direct me to areas I should look into.
First off let me say that everything was fine and worked great up until 3 weeks ago.
Then all of a sudden we began to experience timeouts on a particular query.
The vb.net 2002 code has not changed and is pretty basic stuff to connect to the server and execute the query. The only change I have made to it since then is to add a commandtimeout parameter so it would actually run.
There does not seem to be a specific pattern either to when it runs slow and when it does not.
I can be the only one in the server in the morning (the only one in the office for that matter) and one day the application will execute the query and return data in under 9 seconds and the next day it will be a minute and a half.
I can test it during peak network times and the same thing...one day fine the next day performance is slow.
Also, if I run the query straight from the management studio it will run in 2-9 seconds and from .net it takes 20-90 seconds.
Are there server admin jobs I could run to see if tables are deadlocked, if the network is to busy..anything?