Database Access (client) to Specific machines in LAN network.

Hi ,
We have a LAN set up in our company . I want that some specific local
machine's IP addresses to have access the live database server.
Want to restict machine's IP address from connecting to the live database
. How can I go for this ? I donot have that much idea about firewall and
router stuff . pls send me the link also which will help me in doing this.
I do have complex password for SA and have created a different login /role
and users for specific rights .But still want to do the above thing to make
the database more secured.
Pls help me in this.
Regards,
Swatiusing ipsec u can achive this. It is a filter. u can allow and disallow i.ps
.
"swati" wrote:

> Hi ,
> We have a LAN set up in our company . I want that some specific local
> machine's IP addresses to have access the live database server.
> Want to restict machine's IP address from connecting to the live databas
e
> .. How can I go for this ? I donot have that much idea about firewall and
> router stuff . pls send me the link also which will help me in doing this.
> I do have complex password for SA and have created a different login /role
> and users for specific rights .But still want to do the above thing to mak
e
> the database more secured.
> Pls help me in this.
> Regards,
> Swati
>
>
>
>|||Hi Suresh ,
Canyou pls throw some light on how to use the ipsec ? I am totally new in
this area . Waiting for your reply
Thanks & Regards,
Swati
"suresh" <suresh@.discussions.microsoft.com> wrote in message
news:35ED9BA4-EC43-4350-9CBE-81141FC72466@.microsoft.com...
> using ipsec u can achive this. It is a filter. u can allow and disallow
i.ps.[vbcol=seagreen]
>
> "swati" wrote:
>
database[vbcol=seagreen]
and[vbcol=seagreen]
this.[vbcol=seagreen]
/role[vbcol=seagreen]
make[vbcol=seagreen]|||http://www.microsoft.com/technet/it...ty/ipsecld.mspx
Using IPSec to Lock Down a Server
is a good start
Cheers
Ken
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:O3U6tii7EHA.2608@.TK2MSFTNGP10.phx.gbl...
> Hi Suresh ,
> Canyou pls throw some light on how to use the ipsec ? I am totally new in
> this area . Waiting for your reply
> Thanks & Regards,
> Swati
>
> "suresh" <suresh@.discussions.microsoft.com> wrote in message
> news:35ED9BA4-EC43-4350-9CBE-81141FC72466@.microsoft.com...
> i.ps.
> database
> and
> this.
> /role
> make
>

Data/Transaction log files for two databases have same file name

We have two db's. One live and one test.

When I right click on the live one in SQL Enterprise Manager and
select properties -> Data Files ->
File Name is LIVE.MDF
Location is F:\Data\LIVE.MDF

When I right click on the test one in SQL Enterprise Manager and
select properties -> Data Files ->
File Name is LIVE.MDF
Location is F:\Data\TEST.MDF

Same thing applies to Transaction log files too.

My concern is File Name is same in both the above cases even though
the location is different. What are the consequences of this.

Thanks for your help

GVVGirish (kattukuyil@.hotmail.com) writes:
> When I right click on the live one in SQL Enterprise Manager and
> select properties -> Data Files ->
> File Name is LIVE.MDF
> Location is F:\Data\LIVE.MDF
> When I right click on the test one in SQL Enterprise Manager and
> select properties -> Data Files ->
> File Name is LIVE.MDF
> Location is F:\Data\TEST.MDF
> Same thing applies to Transaction log files too.
> My concern is File Name is same in both the above cases even though
> the location is different. What are the consequences of this.

Nothing. The filename in question is just a logical name within the
database.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Data Transfer Wizard - Not Copying properly

Here is the scenerio

I am trying to copy a database from a live sql server to a local server.

I wanted to copy the tables, triggers, procedures, functions, users

So I have "Copy tranfer of objects " in the DTS wizard.

But the process fails informing that the users are not there in the local server and fails the process.

Now what is my expectation is that why the user logins every thing is not copied to the local sever.

Help would be more appreciated. Pretty urgent.

The quick, easy and reliable way is to backup the live one and restore on the local server it moves everything and gives you the option to change the name of the database. In the backup and restore wizard choose restore from device option, known issues orphaned permissions just delete that restore and create a new one. The other valid option is to dettach and attach but the former is the best I know. Hope this helps.|||

I tried your solution.

This are the steps i follow to do the backup.

1. I select the database from the live server.

2. I wanted to give a file name and need to specify a location.

3. I am not able to specify a location of my local drive instead i am able to specify a location of the live server harddisk which is of no

use to me as i am not able to restore because i dont have access to the live server system.

Solution is pretty urgent.

|||

I think DTS not is properly executed when a field is having a datatype of image in a table.

As the "image" field is holding a binary value it is not properly performed.

How to Replicate the use.

1. Create a database and a table with a field "projectimage" and set it datatype as image.

2. Now try doing DTS and create a new database using DTS

3. I hope the error would be replicated.

::Error::
Transfer Status: Transferring Data: (Table '[dbo].[<tablename]')
Data truncation occurred in table [dbo].[tablename], column 1.

any solutions would be more appericated

|||Now to the correct way to use the backup and restore wizard, is because it is a backup in a different server you put the .bak in the backup subfolder in programs , Microsoft SQL Server, Backup you put the file there and then let Windows create the file path for you when you choose the restore from device option in the wizard that is the most important part because if you don't SQL Server gets confused. So try these instructions and post again. I am sorry I did not add this part in my first post, Hope this helps.|||

Hi caddre, I am looking for more help from you.

In the backup option of live server it shows the files and folder of the live server and not of local disk nor any shared directory. -This is the problem

Similarly in

the backup option of local server it shows the files and folder of the local server and not of the live server.

So I dont find any common place to restore the database.

Please consider that i dont have any access to live server.

|||

I have figured out the solution in msdn

http://support.microsoft.com/kb/257425

|||I am glad you got it resolved but you did not undersatnd my instruction because if you email me your .bak I can restore it in less than five minutes. You can put your .bak in a CD post it to me and I can still restore it in five minutes it is the most efficient way to move SQL Server databases.|||

I Found that was the actually problem but unable to resolve it.

The problem seems to be occur in sql server 7.0 and not in sql server 2000.

I am using sql server 2000 and win xp but still not able solve it.

I need a step by step details or screen sheets would be more helpful.

|||

I have restored SQL Server 7.0 in SQL Server 2000 and 2000 is very good it will ask you if you want to keep TDS(tabular data stream) 70 that is 7.0 compatibility and the .bak was emailed to me on the company network.

Here are the steps right click on the SQL Server 7.0 database go to all tasks and then backup, then use the backup and restore wizard to do a full backup, when you have completed the backup use any zip software like winzip and zip it. Then take the .bak file when you go into SQL Server 2000 in xp go to programs Microsoft SQL Server then there are two subfolders one is the Data folder where the MDF,LDF and IDF are stored the other one is the backup put your .bak there, then go to the backup and restore wizard back in Enterprise manager and click to create a restore it will ask for the location of the .bak file. This is the very important part when you choose restore from device it will want to know the file part click on the ellipse Windows will create the file part for you don't try to create it because if you do SQL Server will get confused, after Windows create the file part you are almost there, it will ask if you want to change the name of the database. There are many threads here where I have helped others and the problem is always the file path let Windows create it but also verify it is correct. Post again if you still have question.

|||

1Here are the steps right click on the SQL Server 7.0 database go to all tasks and then backup, then use the backup and restore wizard todo a full backup,

when you have completed the backup use any zip software like winzip and zip it. - This is the problem.

In the Select Backup Database (4th step in the wizard)

I need to give a file location and click the ellipse button to see the files and folder of live server .

I am not able to see the files and folder of local disk. - this is where i dont really understand

I hope now u have got my problem clearly.

|||

You need to take the .bak file physically to your local SQL Server Backup subfolder you cannot try to do the restore on your local drive from the live server, I know you cannot do that with the SQL Server backup and restore wizard.

Take the .bak put it in your local SQL Server backup folder in programs. I will look for the other thread so you may understand, because I think you are trying to restore on the local one from the live server and that is not correct.

|||

You need to take the .bak file physically to your local SQL Server Backup subfolder you cannot try to do the restore on your local drive from the live server, I know you cannot do that with the SQL Server backup and restore wizard - This is the problem.

I dont have the access to copy the .bak file from live server to local disk.

Is there is any work around.

|||

See if you can register the live server on your local SQL Server right click at the top of Enterprise Manager you will see register server if you can register it then it becomes local to you and you can just copy the .bak into this physical location. If you cannot then you have to create a blank database in your local XP and use DTS to move the data into your local machine. Hope this helps.

C:\Program Files\Microsoft SQL Server\MSSQL$SQLSERVER03\BACKUP\

|||

you can just copy the .bak into this physical location - this is the problem.

1. I am able to register the live server in my local server and able to create the .bak file but unable to copy the .bak into this physical location of local

disk. 2.I have tried using DTS, Then only I faced the problem of the image field

The first option is ruled out because iam not able to access it

ie i am using DTS and finding problem with image field which gives me the following error.

::Error::
Transfer Status: Transferring Data: (Table '[dbo].[tablename')
Data truncation occurred in table [dbo].[tablename], column 1

This is a problem in sql server 7.0 and getting solved using sp4 but still iam facing the same problem with sql 2000 and win xp

which i dont know why?

I hope now things clear and leaving for End of Day and hope to see u in the morning.