MSSQL Over Internet
Jan 1, 2008
I am tuning up a stalled ASP.NET2.0 community website.
The latter accesses MS SQL Server2005 (SS2005) database over internet.
The website and SS2005 are on different machines and even networks communicating over internet.
They are on shared public hosting that I access through Helm control panel.
The accounts are very restrictive to check most of configurations.
What are possible pitfalls, configurations, security configurations and dangers,
optimizations for accessing SS2005 over internet?
View 3 Replies
ADVERTISEMENT
Aug 11, 2004
How many result-rows does mssql return should be used asynchronous method to use mssql cursor, can get the best performance in any time in any result offset?
i want to make the cursor fast in any time whatever how many results returned
View 2 Replies
View Related
Feb 10, 2008
Hi,
i was planning to create a database migration tool ..
its a certain database of a DMS (document management system) to
another DMS (two different DMS)... from DMS using msde 2000 server .. and tranfer to a DMS using a postgre sql or mssql .. depends ..
they have different table structures and names . . :D
i was thing of what language shall i use.. or what language is the best to work on this kind of project :)
hoping for your kind help guys. thanks :)
br
Frozenice
View 1 Replies
View Related
Sep 6, 2006
Does enabling/disabling Data Execution Prevention have a performanceimpact on SQL 2000 or SQL 2005?For SQL best performance - how should I configure for:Processor Scheduling:Programs or Background servicesMemory Usage:Programs or System Cache
View 9 Replies
View Related
Mar 24, 2008
Hi,
I am a bit new to the MSSQL server. In our application, we use so many SQL queries. To imporve the performance, we used the Database enigine Tuning tool to create the indexes. The older version of the application supports MSSQL 2000 also. To re-create these new indexes, I have an issue in running these "CREATE INDEX" commands as the statements generated for index creation are done in MSSQL 2005. The statements include "INCLUDES" keyword which is supported in MSSQL 2005 but not in MSSQL 2000.
Ex:-
CREATE INDEX IND_001_PPM_PA ON PPM_PROCESS_ACTIVITY
(ACTIVITY_NAME ASC, PROCESS_NAME ASC, START_TIME ASC, ISMONITORED ASC)
INCLUDE
(INSTANCE_ID, ACTIVITY_TYPE, STATUS, END_TIME, ORGANIZATION);
Any help in creating such indexes in 2000 version is welcome.
Thanks,
Suresh.
View 2 Replies
View Related
May 3, 2008
Hello
We are using SQL 2005 and now we are planning to use SQL 2000. what are the ways to do the process.
We taken the script spcificall for 2000 and run it in SQL 200. But we are getting the error in SCRIPT?
Could you please give me the step to do?
Thanks,
Sankar R
View 6 Replies
View Related
Oct 26, 1999
Hello:
I am currently work on mssql 6.5. On my workstation, I have mssql 6.5
cient software.
However, I would like to install mssql 7.0 server on my nt workstation
and work with it to become familiar with 7.0. Can I install mssql 7.0
server on my nt workstation? Can mssql 6.5 client coexist with mssql 7.0
on the same machine if they are in different directories?
Thanks.
David Spaisman
View 1 Replies
View Related
Jun 15, 2006
Ben writes "I have a sql script that doesn't function very well when it's executed on a SQL 2000 server.
The scrpt looks like this:
---------------------------------------------------------------------------------------------------
USE [master]
GO
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME')
EXEC sp_addlogin N'SSDBUSERNAME', N'SSDBPASSWORD'
GO
GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME]
GO
GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME]
GO
GRANT CONNECT SQL TO [SSDBUSERNAME]
GO
GRANT CONTROL SERVER TO [SSDBUSERNAME]
GO
GRANT CREATE ANY DATABASE TO [SSDBUSERNAME]
GO
USE [master]
GO
If EXISTS (Select * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME')
ALTER LOGIN [SSDBUSERNAME] WITH PASSWORD=N'SSDBPASSWORD'
GO
GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME]
GO
GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME]
GO
GRANT CONNECT SQL TO [SSDBUSERNAME]
GO
GRANT CONTROL SERVER TO [SSDBUSERNAME]
GO
GRANT CREATE ANY DATABASE TO [SSDBUSERNAME]
GO
USE [master]
GO
IF EXISTS (select * from dbo.sysdatabases where name = 'ISIZ')
DROP DATABASE [ISIZ]
GO
USE [SurveyData]
GO
exec sp_adduser 'SSDBUSERNAME'
GRANT INSERT, UPDATE, SELECT, DELETE
TO SSDBUSERNAME
GO
USE [SurveyManagement]
GO
exec sp_adduser 'SSDBUSERNAME'
GRANT INSERT, UPDATE, SELECT, DELETE
TO SSDBUSERNAME
---------------------------------------------------------------
I need to be converted to a script that can be executed on both MSSQL 2000 and MSSQL 2005.
I was wondering if somebody there could help me with this problem?!
Thanks,
Ben"
View 1 Replies
View Related
Nov 17, 2007
I've been tasked to move our production databases on MSSQL 2000 to 2005. I've supported MSSQL since version 6.5 and performed migrations to successor versions.
Current Environment is MSSQL 2000 32-bit with current Service Packs.
I've performed mock migrations on Test servers upgrading all Production instances simultaneously from MSSQL 2000 to 2005 32-bit. The Test environment is identical to Production minus server name, IP etc. Also I have a separate server with MSSQL 2005 installed where I use the DETACH / ATTACH and BACKUP / RESTORE method for migration / acceptance testing. There are approximately 30 databases totaling 70 GB. This has gone as expected and fairly successful. Vendors have been coordinated with to update code and staff for acceptance testing.
I'd prefer going directly to MSSQL 2005 64-bit instead if possible due to memory benefits etc. This is where I'd like some feedback prior to borrowing a 64-bit server for testing.
Upgrade options:
1. Is it better to migrate from MSSQL 2000 32-bit to 2005 64-bit via:
a. DETACH / ATTACH
b. BACKUP / RESTORE
c. Is one method more advantageous relating to the end result?
2. Regarding XP clients, have issues been experienced with the default SQL Server driver or is an alternate recommended for XP clients to connect to a MSSQL 64-bit server databases?
3. If you have performed this migration and have relevant experience please pass them along.
View 3 Replies
View Related
Sep 29, 2006
DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?
I have tried several approaches.
A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
C: I have also tried opening the Database, and back up file through Server Management Studio. without success.
D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.
I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.
Mark Roach
View 5 Replies
View Related
Jul 5, 2001
I am trying to connect to SQL Server 2000 using the enterprise manager, and I want to do it over the Internet. My server is in another country and I am using SQL authentication. When I try to make the connection I get a message of server does not exists or access denied. If I ping the server the ping is successful, I am using TCP/IP as protocol for the client, I am not behind any firewall, and the port 1433 is enabled and is the default. I imagine it has to be something with permissions but since I am using SQL validation it should work. Is there something else I have to change?
View 2 Replies
View Related
Jul 11, 2001
Hello,
I am trying to upload a database (MS SQL 7) from my machine to a remote location (host company). This company has MS SQL Server 7 running in its machine, so they told me that all I had to do was to connect from my SQL Enterprise Manager. I am new to MS SQL, so I would appreciate if someone can help me to create a connection from Enterprise Manager to this remote SQL Server.
Thanx
View 1 Replies
View Related
Jul 16, 2001
I need to access my SQL server from another domain across the internet. How can I do this? Everything I have tried has been unsuccessful.
Chris Walcott
View 2 Replies
View Related
Jan 21, 2000
Hi
Could someone help me out with administration of SQL Server over the internet.
What do I need to change on my SQL Server and what will I need to configure on my clients using SQL analyzer connecting over the internet
Vijay
View 1 Replies
View Related
Mar 13, 2000
Hi,
I am developing a VB app that will be accessed over the net. What do i need to do so that my users will be able to connect to the SQL server without being denied the permission.
a hind regarding the network library settings will be most appreciated.
Thanks in advance.
Deepak.
View 2 Replies
View Related
Feb 9, 2000
I would like to know how I can make data from sql 6.5 availeble for viewing on the internet. I think that I have to use ASP but how to implement this and what the steps are to follow is a big mystery for me, so if someone can the me more about this....
View 3 Replies
View Related
Mar 29, 1999
Hello,
I will soon be managing a sqlserver/iis4.0/nt box located remotely in another state. It has a permanen connection to the net. I have a dialup connection.
I have a remote control package, but it is slow. Is there a way to add that boxes sql server to my enterprise manager on my local nt server so that I can
adminsiter it from my machine? I am not over familair with sql server, but quickly learning!
Will I need to set up a vpn to do that?
I searched microsoft knowledge base, but could not find anything.
Thanks for your support.
Johanna
View 2 Replies
View Related
Aug 6, 2001
Hi,
I am trying to replicate using Win 2000 and Sql 2000 on the Internet(FTP) using merge replication
The seqence of Activities are
..Intializing
..Connecting to publisher 'PUBSERVER'
..Retrieving publication Information
..Retrieving Subscribtion Information
..The subscription has been marked for reintialization.Reinitialization will occur the next time you synchroize this subscription
..The schema script 'Pubserver.. .. emp_1.sch' could not be propagated to the subscriber.
..The schema script 'Pubserver.. .. emp_1.sch' could not be propagated to the subscriber.
..The process could not read the file 'Pubserver....emp1.sch due to OS error 53
Can you help me out with this
(Please not I was able to replicate on the LAN with the same setup)
Regards
Anil
View 2 Replies
View Related
Dec 9, 2004
Hello again pals, i meet you again to ask an old question i had, but no found answer.
Can i connect to a remote SQL Server thru Internet, lets say from a client like Query Analyzer?
I read to make it using a VPN, but i try to configure it and cant get connected.
I'm using a Win2000 Server or Win2003 Server,
Thanksfull!!!!
There is many people asking for that, i start to think it cant be done! :'(
View 6 Replies
View Related
Jan 11, 2006
Hi,
Now I really need you help. I have an application that needs to conect to a server
over the internet and I have change the MSQL port to 2015 cos the server even with a
firewall it has been attempt to be hacked. So I needed to change the port but my application
cannot conect to the server if I change it. If I left in the firewall 1433 and SQL it works fine
but once I change it to 2015 it doesnīt work.
Iīm using ADO conection as folow:
Variables string parameters:
01=password
02=user
03=database
04=server IP adress
"Provider=SQLOLEDB.1;Password='+01+';Persist Security Info=True;User ID='+02+';Initial Catalog='+03+';Data Source='+04;"
Using this conection string I can conect to the server using 1433 port but if I change the port I get the folow message:
"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
Iīd try to add the new port number to IP adress but it doesnīt work as (200.121.65.140:2015) and it return the folow message:
[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.
What I need to know or to do? Please somebody help me cos I donīt know more what to do and my superiors need awnsers.
Thanks for attetion.
Leonardo Almeida.
View 3 Replies
View Related
Sep 23, 2006
hello,
we are learning sql2000 at school. i have been put in charge of trying to make it possible for the students to connect to the sql database from home.At the college they connect via a lan. Can anyone give me a way to do this, or is there a way. There are 30 students who will need to connect not all at the same time. Besides buying something like pcanywhere is it possible and how. I would really appreciate it. thanks again, tom
View 2 Replies
View Related
Jun 17, 2008
Please help me connect sql server over internet. I tested the connection in Windows XP, SQL Sever 2000, Router (forwarding IP port 1433) and its is working properly.
But using the same process in Windows 2000 Advance Server, Microsoft SQL Server 2000, Router (forwarding IP port 1433) Im getting the error "Unable to connect to server" . Can any one help me to setup this network. Thank you in advance!
View 11 Replies
View Related
Jan 22, 2007
it is my first time using SQL remotely, i am used to client/server ..
i need to run query and execute procedure remotely.
i have SQL server 2000 installed on one machine connected to the internet with static IP adress, the second machine does not have SQL server but also connected on the internet but different cities.. so how that can be possible?
i am using VB6 to and ODBC, i need to know the full code to execute procedure or run query and what i have to do on the first machine to let it work and give me access over the internet?
View 1 Replies
View Related
Jan 3, 2007
From what I have understood, Reporting Services could be configured to use Basic Authentication. In this way, a user can access a RS-server across the internet and he/she will be prompted for a valid username/password when trying to access.
However, from what I can understand this username and password will be sent uncrypted over the Internet (from the client machine to the RS-server), right?
My problem is, I need to give access to users acress the internet to a RS-server. The users uses all kind of operating systems (Windows, Linux, MacOS tec). And the communication needs to be encrypted.
How would you recommend me to implement security for this solution? I guess some kind of "Forms authentication" will have to be used? But how to make sure the data traffic is encrypted? And where do you recommend me to store the username and passwords? In an Active Directory on the server side, or in a separate database on the server side?
regards Andreas
View 7 Replies
View Related
Jun 1, 2008
I have just started on SQl Server and C# and was wondering if the following is possible.
Using a Windows application, is it possible to connect to a database held on another computer via the Internet? I am not talking about a local network / domain whatever.
What I am really asking is can you use the IP address of a 'real' remote computer in the connection string or is it done some other way?
John
View 1 Replies
View Related
May 31, 2007
Can SQL Server do mirroring over Https protocol over internet?
View 3 Replies
View Related
May 5, 2008
Hi all,
I really need help with this issue.
I have a setup a reporting server that works perfectly when accessing it from the intranet. Now I need to give access to this report server over the intranet.
I'm stomped...
The network guys did create a secure access to my report server so I can access my server using :
https://<MySecureRS>/reports
The issue I'm facing is that once I authenticated my self using https://<MySecureRS>/reports
It shows the internal ip addres of my server in the browser.... http://<My internal IP Adress>/reports
How can I configure my server to stay on my secure address?
Thanks
Aiwa
View 4 Replies
View Related
Jan 6, 2006
Hi.. need some help!
My problem is thus - I am looking for a
synchronization technique (between SQLCE and SQL Server 2000) for a PPC
which can not connect to the internet.
I am not sure at this stage if the device would even be equipped with a
network adapter.I
would be using RDA to sync with the database. The only problem is that I am unable to access IIS directly from the PDA.
I did some research and found out that SQL CE Relay
is one way to achieve what I am looking for but Darren let me know that
Relay is outdated and might not be supported anymore. I tried working
with relay but in vain.
I thought of using Pocket Access instead but Pocket Access
does not have the ability to handle the db I am using neither is it
being supported anymore.
I am fast running out of ideas:(
Could someone please suggest me alternatives or any available solution
to deal with the problem for a PPC with / without a network adapter.
Thanks in advance!
Abhi.
View 3 Replies
View Related
May 3, 2008
I have 2 instances of SQL-Server 2000 running on my computer.
I connected to them through SQLServer enterprice Manager.
Now I want to connect to a Database that is stored on my WebHosting-Site [on INTERNET]
The Server-IP address is 65.22.42.57.etc..........
WHILE I can connect to That Database from Visual-Studio server-Explorer..........I cannot connect to that server from SQLServer-EnterpriceManager.
It says 'You need to use SQLServer 2005 tool'.
But there is no Connect-word to create a connection in 'SQLServer 2005'-Manager.'
HELP I need to connect , what shall I do ?
EXPERTS.
View 2 Replies
View Related
Mar 16, 2004
Hi,
What is a secure way or accepted method to make database changes,IE: edit tables, add sprocs. ect. on a server being ran by an ASP.NET hosting service across the internet?
Thank you
-heywade
View 2 Replies
View Related
Oct 18, 2000
i want to connect to remote sql server through ip address
iam using winnt server 4.0 and sql 7.0
View 1 Replies
View Related
Feb 26, 2003
I have a Analysis Servises installed in a Windows 2000 server and I created
a cube on it. I created also an ASP page with Web Pivot Control to access
the cube, but when the users open my ASP page they canīt access the cube. Their machines
doenīt have Excell 2000 installed.
Is it necessary to heve the Pivot table Service installed in the user machine? Or I only have toinstall the Office Web Components ? Or both?
If
itīs true how can I install Pivot Table Service in the user machine? Is
there a specific setup program to install it or is the same setup program
used to install Analysis Services? How should I do this? Should I have a
link in the ASP page to run the setup program? Should I do a download?
Thanks,
Paulo Ortega
View 2 Replies
View Related
Oct 27, 2005
My English is not good.
I want to connect to other computer that installed M$ SQL Server2K over INTERNET. could you help me, plz.
I have used DNS (DOMAIN NAME SYSTEM) to forward to my computer( that connect to INTERNET) and my friend computer is the same. (because we have not static IP).
Thanks
:D
View 7 Replies
View Related
