Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Server NameAuthentication TypeUserPasswordUse Same CredentialsWindows UserWindows User PasswordPort numberServer Type

FINSVR

0

myhouse\william

Test123

TRUE

,

,

1433

0

SQLSVR1

0

thathouse\jim

Num1DBA

FALSE

Tools

Test123

1433

0

accidera1

acidr1.

accoliteindia

usercntry.com\MSSQLSERVER1  

2

temp@xyz.com

abc@1234

TRUE

,

,

1433

1

sqlsecureacc.database.windows.net

2

test@accolitelabs

test@clientlabs.com  

abc@1234

TRUE

,

,

1433

2

IDERA

IDR-SQL2008R2

.CSZUD3HACSPL

.US-EAST-1.RDS.AMAZONAWS.COM

3

accolitelabs

clientlabs\administrator1

control*123

FALSE

,

,

1433

3

ec2

ec3-

52

53-0-

82

86-183.

compute

computeIDR-1.amazonaws.com

0

simpsons

simpclient\administrator

control*159

TRUE

,

,

1433

4

Sample .csv file:

Server Name,AuthType,User,Password,UseSameCredentials,WindowsUser,WindowsUserPassword

FINSVR1,0,myhouse\william,Test123,TRUE,,,,, 1433, 0

SQLSVR1,0,thathouse\jim,Num1DBA,FALSE,Tools,Test123,1433,0

accidera1acidr1.accoliteindiausercntry.com\MSSQLSEVER1MSSQLSERVER1,2,temp@xyz.com, abc@1234,TRUE,,, 1433, 1

sqlsecureacc.database.windows.net, 2, test@accolitelabstest@clientlabs.com, abc@1234,TRUE,,, 1433, 2

IDERAIDR-SQL2008R2.CSZUD3HACSPL.US-EAST-1.RDS.AMAZONAWS.COM,3,accolitelabsclientlabs\administrator1,control*44,FALSE,,,1433,3

ec2ec3-5253-0-8286-183.computecomputeIDR-1.amazonaws.com ,0,simpsonssimpclient\administrator,control*44,TRUE,",",",",1433,4


Info

The first row in the previous table must be included in the .csv file as shown.

...