Hi,
I am taking a diff backup of a read only database over a
network link but the size of the diff backup is the same
as the normal backup.
Is there any thing that I need to take in account as the
database is sometimes put to read write and then to read
only mode so need a differential
Thanks
AnupHi
Eventually. enough pages would have changed in the DB that the differential
is the same as a normal backup.
e.g.
If every index in clustered, and every index gets re-built, in effect the
whole DB's pages will have changed.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ap" <anonymous@.discussions.microsoft.com> wrote in message
news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
> Hi,
> I am taking a diff backup of a read only database over a
> network link but the size of the diff backup is the same
> as the normal backup.
> Is there any thing that I need to take in account as the
> database is sometimes put to read write and then to read
> only mode so need a differential
> Thanks
> Anup|||Checked all but no such thing something has changed so
any ideas what to do ?
>--Original Message--
>Hi
>Eventually. enough pages would have changed in the DB
that the differential
>is the same as a normal backup.
>e.g.
>If every index in clustered, and every index gets re-
built, in effect the
>whole DB's pages will have changed.
>Regards
>--
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>IM: mike@.epprecht.net
>MVP Program: http://www.microsoft.com/mvp
>Blog: http://www.msmvps.com/epprecht/
>"ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00f401c5185f$39b32a50$a601280a@.phx.gbl...
>> Hi,
>> I am taking a diff backup of a read only database over
a
>> network link but the size of the diff backup is the
same
>> as the normal backup.
>> Is there any thing that I need to take in account as
the
>> database is sometimes put to read write and then to
read
>> only mode so need a differential
>> Thanks
>> Anup
>
>.
>|||Hi,
When was the last full backup taken?
I suggest that you take a latest full backup and then the differential
backup. If you still have the same question, please let us know the size of
the original full backup file vs differential backup file size.
--
Thanks
Yogishsql
Showing posts with label network. Show all posts
Showing posts with label network. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
Did anyone get this error on a backup job?!
Additional information --> Job Owner: SA
In my DB Backup JOB my first step is to map a network path like this
NET USE Z:\\SERVER2\DADOS /user somebody 234567
I got this Error --> Executed as user: MYSERVER\SYSTEM. System error 1312 has occurred. A specified logon session does not exist. It may already have been terminated. Process Exit Code 2. The step failed.
In step 2 i copy all my *.bak files from yesterday to the drive mapped on dir BACKUP in SERVER2.
COPY "C:\BACKUP\*.BAK" "Z:\BACKUP\"
I got this Error --> Executed as user: MYSERVER\SYSTEM. ...annot find the path specified. C:\BACKUP\db_200511030200.BAK The system cannot find the path specified. C:\BACKUP\CFG_db_200511030225.BAK The system cannot find the path specified. C:\BACKUP\STRUCTAL_db_200511030225.BAK The system cannot find the path specified. C:\BACKUP\STRUCTEN_db_200511030225.BAK The system cannot find the path specified.
step 3 i delete all files in MYSERVER C:\BACKUP\*.BAK
This step is OK
step 4 i execute my database maintenance plan
the .bak file are generated and put in "C:\BACKUPS" in MYSERVER
This step is OK
Thanks for all help.First you need to resolve the 1312 error. It may be caused by some sort of delay that occurred between a network connection request initiated by NET USE and the actuaql attempt to map the drive. While on the topic, why do you need to map the drive to begin with?
Second, you need to make sure that the step is executed successfully before moving on. You need to either check for errorlevel or take the step out of the batch and put it by itself into a separate step within the job, and then allow continuation OnSuccess.
In my DB Backup JOB my first step is to map a network path like this
NET USE Z:\\SERVER2\DADOS /user somebody 234567
I got this Error --> Executed as user: MYSERVER\SYSTEM. System error 1312 has occurred. A specified logon session does not exist. It may already have been terminated. Process Exit Code 2. The step failed.
In step 2 i copy all my *.bak files from yesterday to the drive mapped on dir BACKUP in SERVER2.
COPY "C:\BACKUP\*.BAK" "Z:\BACKUP\"
I got this Error --> Executed as user: MYSERVER\SYSTEM. ...annot find the path specified. C:\BACKUP\db_200511030200.BAK The system cannot find the path specified. C:\BACKUP\CFG_db_200511030225.BAK The system cannot find the path specified. C:\BACKUP\STRUCTAL_db_200511030225.BAK The system cannot find the path specified. C:\BACKUP\STRUCTEN_db_200511030225.BAK The system cannot find the path specified.
step 3 i delete all files in MYSERVER C:\BACKUP\*.BAK
This step is OK
step 4 i execute my database maintenance plan
the .bak file are generated and put in "C:\BACKUPS" in MYSERVER
This step is OK
Thanks for all help.First you need to resolve the 1312 error. It may be caused by some sort of delay that occurred between a network connection request initiated by NET USE and the actuaql attempt to map the drive. While on the topic, why do you need to map the drive to begin with?
Second, you need to make sure that the step is executed successfully before moving on. You need to either check for errorlevel or take the step out of the batch and put it by itself into a separate step within the job, and then allow continuation OnSuccess.
Friday, March 9, 2012
DHCP/SQL Problem ?
I run a small network behind an ISA Server and using DHCP to assign NAT
addresses (192.168.x.x)
I have "reserved" 5 addresses for VPN access.
All seems ok, except one of my consultants set up a SQL Server and instance
of the application we support ( a web app) and had several others connect to
it.
They all appear in the DHCP Active Leases, including the "host" with valid
IP addresses, showing their MAC addresses under "Unique ID".
But the host also has several (equal to the number of connections)
additional IP addresses assigned, showing "RAS" under "Unique ID" (as the 5
reserved VPN addresses do).
They are not using RAS, that I know of.
Can anyone explain this to me and/or tell me how to stop it ?
Thanks in advance
--
JIM MATTHEWS
Dallas, TexasI had the same problem too, its nothing but the users of those computers (believe you're using XP) created a connection to accept incoming calls. Once I removed those connection's, the Unique ID started showing the MAC address instead of "RAS" (like anyother computer on the network)
Hope it helps
Sri
Toronto
**********************************************************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
addresses (192.168.x.x)
I have "reserved" 5 addresses for VPN access.
All seems ok, except one of my consultants set up a SQL Server and instance
of the application we support ( a web app) and had several others connect to
it.
They all appear in the DHCP Active Leases, including the "host" with valid
IP addresses, showing their MAC addresses under "Unique ID".
But the host also has several (equal to the number of connections)
additional IP addresses assigned, showing "RAS" under "Unique ID" (as the 5
reserved VPN addresses do).
They are not using RAS, that I know of.
Can anyone explain this to me and/or tell me how to stop it ?
Thanks in advance
--
JIM MATTHEWS
Dallas, TexasI had the same problem too, its nothing but the users of those computers (believe you're using XP) created a connection to accept incoming calls. Once I removed those connection's, the Unique ID started showing the MAC address instead of "RAS" (like anyother computer on the network)
Hope it helps
Sri
Toronto
**********************************************************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
DHCP/SQL Problem ?
I run a small network behind an ISA Server and using DHCP to assign NAT
addresses (192.168.x.x)
I have "reserved" 5 addresses for VPN access.
All seems ok, except one of my consultants set up a SQL Server and instance
of the application we support ( a web app) and had several others connect to
it.
They all appear in the DHCP Active Leases, including the "host" with valid
IP addresses, showing their MAC addresses under "Unique ID".
But the host also has several (equal to the number of connections)
additional IP addresses assigned, showing "RAS" under "Unique ID" (as the 5
reserved VPN addresses do).
They are not using RAS, that I know of.
Can anyone explain this to me and/or tell me how to stop it ?
Thanks in advance
JIM MATTHEWS
Dallas, TexasI had the same problem too, its nothing but the users of those computers (be
lieve you're using XP) created a connection to accept incoming calls. Once I
removed those connection's, the Unique ID started showing the MAC address i
nstead of "RAS" (like anyot
her computer on the network)
Hope it helps
Sri
Toronto
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...
addresses (192.168.x.x)
I have "reserved" 5 addresses for VPN access.
All seems ok, except one of my consultants set up a SQL Server and instance
of the application we support ( a web app) and had several others connect to
it.
They all appear in the DHCP Active Leases, including the "host" with valid
IP addresses, showing their MAC addresses under "Unique ID".
But the host also has several (equal to the number of connections)
additional IP addresses assigned, showing "RAS" under "Unique ID" (as the 5
reserved VPN addresses do).
They are not using RAS, that I know of.
Can anyone explain this to me and/or tell me how to stop it ?
Thanks in advance
JIM MATTHEWS
Dallas, TexasI had the same problem too, its nothing but the users of those computers (be
lieve you're using XP) created a connection to accept incoming calls. Once I
removed those connection's, the Unique ID started showing the MAC address i
nstead of "RAS" (like anyot
her computer on the network)
Hope it helps
Sri
Toronto
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...
Saturday, February 25, 2012
Developing a client server app using SQLServer - Steps
How do we go about setting a C/S application. Here are the steps.
1. Network Operating system.
2. SQL Server 2000 Installation on a Client / Server Network.
3. Install and setup Active Directory Services on a Client / Server
Network.
4. Concept of Domain Controller in a Windows Network.
5. Setup a Domain Model and Client / Server Model on a Network.
6. Secure Databases in Sql Server.
7. Setup and use Windows Authentication in Sql Server.
8. Setup and use SQL Server Authentication.
9. Create Logins in Sql Server.
10. Define Database Roles in Sql Server.
11. Define Server Roles in Sql Server.
12. Use the Enterprise Manager of Sql Server.
13. Use the Query Analyzer of Sql Server.
14. Create a Database.
15. Create a Table using SQL Script.
16. Create Primary Keys and Foreign Keys.
17. Create Indexes, Clustered and Non Clustered Indexes.
18. Establish Connection with SQL Server over a Network.
19. Create a Connection Object.
20. Create a Command Object, its Properties and Methods.
21. Create a Recordset Object in a Visual Basic ( VB ) application.
22. Access SQL Server Database using ADO.
23. Retreive Data From SQL Server Over a client server Network.
24. Create Multiple Command Objects using a Single Connection.
25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client
server application.
26. Pass Connection Information to SQL Server over a network using
Visual Basic ( VB.).
27.Insert a New Record in SQL server using Visual Basic ( VB ).
28.Update and Delete a record using the Execute Method.
29.Execute a Stored Procedure using a Command Object.
30.Create a Input Parameter.
31.Create a Output Parameter.
32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets,
Forward Only Recordsets.
33.Create Client Side Only Recordsets.
34.Assign a lock for Client Side Recordsets.
35.Navigate and Bind Controls to a Recordset.
36.Retrieve Fields of Recordsets.
37.Manually Populate Controls.
38.Add a new Record, Modify and Delete a Record.
39.Setup a DNS server.
40.Setup a DHCP Server.
41.Assign IP Address in a Client Server network.
42.Setup a Network Topology.
43.How to Create a Project.
44.How to Create a Menu.
45.SQL Server Security.
46.Standard Security Mode.
47.Setup a Integrated Security Mode.
48.Create Constants.
49.Relational Databases are used in a Client Server Accounting
application.
50.Implement relationships using Key Fields.
51.Client/Server Architecture.
52.Create a Class for developing a database application.
53.Object Oriented Programming is used in a VB/SQL Environment.
54.Use a Datagrid in a VB, Sql server accounting application.
55.Create and Use Standard Modules in a database application.
56.Design the database using SQL Server.
57.Program the Form_Load() event procedure.
58.Program the Form_Activate() event procedure.
59.Program the Cancelbutton.
60.Setup and Validate the data entered in the text box control.
61.Create and Add a Class using Visual basic ( VB ) for a client server
application.
62.How to write Property Procedures.
63.How to write Get Property Procedure.
Any questions email me. Before that you can have a look at the FAQ i
have collected and posted here http://www.vkinfotek.com/faq.html
Regards
MadhWha-a-a-a-t?
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<pedaammulu@.yahoo.com> wrote in message
news:1151489920.428568.278820@.x69g2000cwx.googlegroups.com...
> How do we go about setting a C/S application. Here are the steps.
> 1. Network Operating system.
> 2. SQL Server 2000 Installation on a Client / Server Network.
> 3. Install and setup Active Directory Services on a Client / Server
> Network.
> 4. Concept of Domain Controller in a Windows Network.
> 5. Setup a Domain Model and Client / Server Model on a Network.
> 6. Secure Databases in Sql Server.
> 7. Setup and use Windows Authentication in Sql Server.
> 8. Setup and use SQL Server Authentication.
> 9. Create Logins in Sql Server.
> 10. Define Database Roles in Sql Server.
> 11. Define Server Roles in Sql Server.
> 12. Use the Enterprise Manager of Sql Server.
> 13. Use the Query Analyzer of Sql Server.
> 14. Create a Database.
> 15. Create a Table using SQL Script.
> 16. Create Primary Keys and Foreign Keys.
> 17. Create Indexes, Clustered and Non Clustered Indexes.
> 18. Establish Connection with SQL Server over a Network.
> 19. Create a Connection Object.
> 20. Create a Command Object, its Properties and Methods.
> 21. Create a Recordset Object in a Visual Basic ( VB ) application.
> 22. Access SQL Server Database using ADO.
> 23. Retreive Data From SQL Server Over a client server Network.
> 24. Create Multiple Command Objects using a Single Connection.
> 25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client
> server application.
> 26. Pass Connection Information to SQL Server over a network using
> Visual Basic ( VB.).
> 27.Insert a New Record in SQL server using Visual Basic ( VB ).
> 28.Update and Delete a record using the Execute Method.
> 29.Execute a Stored Procedure using a Command Object.
> 30.Create a Input Parameter.
> 31.Create a Output Parameter.
> 32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets,
> Forward Only Recordsets.
> 33.Create Client Side Only Recordsets.
> 34.Assign a lock for Client Side Recordsets.
> 35.Navigate and Bind Controls to a Recordset.
> 36.Retrieve Fields of Recordsets.
> 37.Manually Populate Controls.
> 38.Add a new Record, Modify and Delete a Record.
> 39.Setup a DNS server.
> 40.Setup a DHCP Server.
> 41.Assign IP Address in a Client Server network.
> 42.Setup a Network Topology.
> 43.How to Create a Project.
> 44.How to Create a Menu.
> 45.SQL Server Security.
> 46.Standard Security Mode.
> 47.Setup a Integrated Security Mode.
> 48.Create Constants.
> 49.Relational Databases are used in a Client Server Accounting
> application.
> 50.Implement relationships using Key Fields.
> 51.Client/Server Architecture.
> 52.Create a Class for developing a database application.
> 53.Object Oriented Programming is used in a VB/SQL Environment.
> 54.Use a Datagrid in a VB, Sql server accounting application.
> 55.Create and Use Standard Modules in a database application.
> 56.Design the database using SQL Server.
> 57.Program the Form_Load() event procedure.
> 58.Program the Form_Activate() event procedure.
> 59.Program the Cancelbutton.
> 60.Setup and Validate the data entered in the text box control.
> 61.Create and Add a Class using Visual basic ( VB ) for a client server
> application.
> 62.How to write Property Procedures.
> 63.How to write Get Property Procedure.
> Any questions email me. Before that you can have a look at the FAQ i
> have collected and posted here http://www.vkinfotek.com/faq.html
> Regards
> Madh
>
1. Network Operating system.
2. SQL Server 2000 Installation on a Client / Server Network.
3. Install and setup Active Directory Services on a Client / Server
Network.
4. Concept of Domain Controller in a Windows Network.
5. Setup a Domain Model and Client / Server Model on a Network.
6. Secure Databases in Sql Server.
7. Setup and use Windows Authentication in Sql Server.
8. Setup and use SQL Server Authentication.
9. Create Logins in Sql Server.
10. Define Database Roles in Sql Server.
11. Define Server Roles in Sql Server.
12. Use the Enterprise Manager of Sql Server.
13. Use the Query Analyzer of Sql Server.
14. Create a Database.
15. Create a Table using SQL Script.
16. Create Primary Keys and Foreign Keys.
17. Create Indexes, Clustered and Non Clustered Indexes.
18. Establish Connection with SQL Server over a Network.
19. Create a Connection Object.
20. Create a Command Object, its Properties and Methods.
21. Create a Recordset Object in a Visual Basic ( VB ) application.
22. Access SQL Server Database using ADO.
23. Retreive Data From SQL Server Over a client server Network.
24. Create Multiple Command Objects using a Single Connection.
25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client
server application.
26. Pass Connection Information to SQL Server over a network using
Visual Basic ( VB.).
27.Insert a New Record in SQL server using Visual Basic ( VB ).
28.Update and Delete a record using the Execute Method.
29.Execute a Stored Procedure using a Command Object.
30.Create a Input Parameter.
31.Create a Output Parameter.
32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets,
Forward Only Recordsets.
33.Create Client Side Only Recordsets.
34.Assign a lock for Client Side Recordsets.
35.Navigate and Bind Controls to a Recordset.
36.Retrieve Fields of Recordsets.
37.Manually Populate Controls.
38.Add a new Record, Modify and Delete a Record.
39.Setup a DNS server.
40.Setup a DHCP Server.
41.Assign IP Address in a Client Server network.
42.Setup a Network Topology.
43.How to Create a Project.
44.How to Create a Menu.
45.SQL Server Security.
46.Standard Security Mode.
47.Setup a Integrated Security Mode.
48.Create Constants.
49.Relational Databases are used in a Client Server Accounting
application.
50.Implement relationships using Key Fields.
51.Client/Server Architecture.
52.Create a Class for developing a database application.
53.Object Oriented Programming is used in a VB/SQL Environment.
54.Use a Datagrid in a VB, Sql server accounting application.
55.Create and Use Standard Modules in a database application.
56.Design the database using SQL Server.
57.Program the Form_Load() event procedure.
58.Program the Form_Activate() event procedure.
59.Program the Cancelbutton.
60.Setup and Validate the data entered in the text box control.
61.Create and Add a Class using Visual basic ( VB ) for a client server
application.
62.How to write Property Procedures.
63.How to write Get Property Procedure.
Any questions email me. Before that you can have a look at the FAQ i
have collected and posted here http://www.vkinfotek.com/faq.html
Regards
MadhWha-a-a-a-t?
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<pedaammulu@.yahoo.com> wrote in message
news:1151489920.428568.278820@.x69g2000cwx.googlegroups.com...
> How do we go about setting a C/S application. Here are the steps.
> 1. Network Operating system.
> 2. SQL Server 2000 Installation on a Client / Server Network.
> 3. Install and setup Active Directory Services on a Client / Server
> Network.
> 4. Concept of Domain Controller in a Windows Network.
> 5. Setup a Domain Model and Client / Server Model on a Network.
> 6. Secure Databases in Sql Server.
> 7. Setup and use Windows Authentication in Sql Server.
> 8. Setup and use SQL Server Authentication.
> 9. Create Logins in Sql Server.
> 10. Define Database Roles in Sql Server.
> 11. Define Server Roles in Sql Server.
> 12. Use the Enterprise Manager of Sql Server.
> 13. Use the Query Analyzer of Sql Server.
> 14. Create a Database.
> 15. Create a Table using SQL Script.
> 16. Create Primary Keys and Foreign Keys.
> 17. Create Indexes, Clustered and Non Clustered Indexes.
> 18. Establish Connection with SQL Server over a Network.
> 19. Create a Connection Object.
> 20. Create a Command Object, its Properties and Methods.
> 21. Create a Recordset Object in a Visual Basic ( VB ) application.
> 22. Access SQL Server Database using ADO.
> 23. Retreive Data From SQL Server Over a client server Network.
> 24. Create Multiple Command Objects using a Single Connection.
> 25. Specify a OLEDB data provider in Visual Basic ( VB ) for a client
> server application.
> 26. Pass Connection Information to SQL Server over a network using
> Visual Basic ( VB.).
> 27.Insert a New Record in SQL server using Visual Basic ( VB ).
> 28.Update and Delete a record using the Execute Method.
> 29.Execute a Stored Procedure using a Command Object.
> 30.Create a Input Parameter.
> 31.Create a Output Parameter.
> 32.Create Dynamic Recordsets, Keyset Recordsets, Static Recordsets,
> Forward Only Recordsets.
> 33.Create Client Side Only Recordsets.
> 34.Assign a lock for Client Side Recordsets.
> 35.Navigate and Bind Controls to a Recordset.
> 36.Retrieve Fields of Recordsets.
> 37.Manually Populate Controls.
> 38.Add a new Record, Modify and Delete a Record.
> 39.Setup a DNS server.
> 40.Setup a DHCP Server.
> 41.Assign IP Address in a Client Server network.
> 42.Setup a Network Topology.
> 43.How to Create a Project.
> 44.How to Create a Menu.
> 45.SQL Server Security.
> 46.Standard Security Mode.
> 47.Setup a Integrated Security Mode.
> 48.Create Constants.
> 49.Relational Databases are used in a Client Server Accounting
> application.
> 50.Implement relationships using Key Fields.
> 51.Client/Server Architecture.
> 52.Create a Class for developing a database application.
> 53.Object Oriented Programming is used in a VB/SQL Environment.
> 54.Use a Datagrid in a VB, Sql server accounting application.
> 55.Create and Use Standard Modules in a database application.
> 56.Design the database using SQL Server.
> 57.Program the Form_Load() event procedure.
> 58.Program the Form_Activate() event procedure.
> 59.Program the Cancelbutton.
> 60.Setup and Validate the data entered in the text box control.
> 61.Create and Add a Class using Visual basic ( VB ) for a client server
> application.
> 62.How to write Property Procedures.
> 63.How to write Get Property Procedure.
> Any questions email me. Before that you can have a look at the FAQ i
> have collected and posted here http://www.vkinfotek.com/faq.html
> Regards
> Madh
>
developers cannot make databases
I need help with a permissions problem. I had my network admin create a AD
group with all my developers in it. I then went to the Enterprise Manager,
then to the Login screen and put that AD group into the the SQL Server. Nex
t, I gave that group the Se
rver Role of "Database Creators". There are no databases in the server othe
r than the standard Master, Model, MSDB and Tempdb. Non of these databases
are checked for access.
My developers are connecting to the SQL Server with the Server Explorer in .
NET2003 but cannot make any databases. We are using Windows Only security o
n the database server. The error message says SQLState 42000 and Error 4064
, Cannot open user default
database login failed.
There is no default database because they have not made one yet.Use Enterprise Manager to determine what the default database is for the
developers group. I'd set it to tempdb, to which everyone automatically has
access.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:A500F9D8-44C7-4488-A61E-96CFE5647932@.microsoft.com...
I need help with a permissions problem. I had my network admin create a AD
group with all my developers in it. I then went to the Enterprise Manager,
then to the Login screen and put that AD group into the the SQL Server.
Next, I gave that group the Server Role of "Database Creators". There are
no databases in the server other than the standard Master, Model, MSDB and
Tempdb. Non of these databases are checked for access.
My developers are connecting to the SQL Server with the Server Explorer in
.NET2003 but cannot make any databases. We are using Windows Only security
on the database server. The error message says SQLState 42000 and Error
4064, Cannot open user default database login failed.
There is no default database because they have not made one yet.
group with all my developers in it. I then went to the Enterprise Manager,
then to the Login screen and put that AD group into the the SQL Server. Nex
t, I gave that group the Se
rver Role of "Database Creators". There are no databases in the server othe
r than the standard Master, Model, MSDB and Tempdb. Non of these databases
are checked for access.
My developers are connecting to the SQL Server with the Server Explorer in .
NET2003 but cannot make any databases. We are using Windows Only security o
n the database server. The error message says SQLState 42000 and Error 4064
, Cannot open user default
database login failed.
There is no default database because they have not made one yet.Use Enterprise Manager to determine what the default database is for the
developers group. I'd set it to tempdb, to which everyone automatically has
access.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:A500F9D8-44C7-4488-A61E-96CFE5647932@.microsoft.com...
I need help with a permissions problem. I had my network admin create a AD
group with all my developers in it. I then went to the Enterprise Manager,
then to the Login screen and put that AD group into the the SQL Server.
Next, I gave that group the Server Role of "Database Creators". There are
no databases in the server other than the standard Master, Model, MSDB and
Tempdb. Non of these databases are checked for access.
My developers are connecting to the SQL Server with the Server Explorer in
.NET2003 but cannot make any databases. We are using Windows Only security
on the database server. The error message says SQLState 42000 and Error
4064, Cannot open user default database login failed.
There is no default database because they have not made one yet.
Sunday, February 19, 2012
Developer edition 2005 upgrade to standard 2005?
We are trying to transisiton our network to sql server 2005... however
havent received our media kit yet for sql server 2005 and probably wont for
a while going by their transit times... we already have the license for sql
server 2005 standard edition but need to get this server up and running
soon! is there any way to install our developer edition copy or install the
trial edition then later "upgrade" to the standard edition license? thanks!Unless it has changed (which I doubt) it is not possible to upgrade from
developer to a licensed edition. You will need to uninstall and reinstall.
Andrew J. Kelly SQL MVP
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||The following article will help when the time comes to move the databases to
the new server instance.
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/kb/224071
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||SQL2005 BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860c-
a95a802898a1.htm
indicates that SQL Server 2005 Developer edition to SQL2005 Standard edition
is one of the supported paths.
But I have not tried to do an in-place upgrade from Dev to Standard.
Linchi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
> Unless it has changed (which I doubt) it is not possible to upgrade from
> developer to a licensed edition. You will need to uninstall and reinstall.
> --
> Andrew J. Kelly SQL MVP
>
> "Brian Henry" <nospam@.nospam.com> wrote in message
> news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
>|||You learn something new every day<g>. Back when 2000 just came out in RTM I
was told by a MS employee that this was not possible and never had a reason
to doubt it. I too would like to actually see it done successfully but it
appears it is possible. Thanks Linchi and sorry Brian.
Andrew J. Kelly SQL MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
> SQL2005 BOL at
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860
c-a95a802898a1.htm
> indicates that SQL Server 2005 Developer edition to SQL2005 Standard
> edition is one of the supported paths.
> But I have not tried to do an in-place upgrade from Dev to Standard.
> Linchi
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
>|||thanks everyone
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OCWCcvXLGHA.3732@.TK2MSFTNGP10.phx.gbl...
> You learn something new every day<g>. Back when 2000 just came out in RTM
> I was told by a MS employee that this was not possible and never had a
> reason to doubt it. I too would like to actually see it done successfully
> but it appears it is possible. Thanks Linchi and sorry Brian.
> --
> Andrew J. Kelly SQL MVP
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
>
havent received our media kit yet for sql server 2005 and probably wont for
a while going by their transit times... we already have the license for sql
server 2005 standard edition but need to get this server up and running
soon! is there any way to install our developer edition copy or install the
trial edition then later "upgrade" to the standard edition license? thanks!Unless it has changed (which I doubt) it is not possible to upgrade from
developer to a licensed edition. You will need to uninstall and reinstall.
Andrew J. Kelly SQL MVP
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||The following article will help when the time comes to move the databases to
the new server instance.
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/kb/224071
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||SQL2005 BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860c-
a95a802898a1.htm
indicates that SQL Server 2005 Developer edition to SQL2005 Standard edition
is one of the supported paths.
But I have not tried to do an in-place upgrade from Dev to Standard.
Linchi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
> Unless it has changed (which I doubt) it is not possible to upgrade from
> developer to a licensed edition. You will need to uninstall and reinstall.
> --
> Andrew J. Kelly SQL MVP
>
> "Brian Henry" <nospam@.nospam.com> wrote in message
> news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
>|||You learn something new every day<g>. Back when 2000 just came out in RTM I
was told by a MS employee that this was not possible and never had a reason
to doubt it. I too would like to actually see it done successfully but it
appears it is possible. Thanks Linchi and sorry Brian.
Andrew J. Kelly SQL MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
> SQL2005 BOL at
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860
c-a95a802898a1.htm
> indicates that SQL Server 2005 Developer edition to SQL2005 Standard
> edition is one of the supported paths.
> But I have not tried to do an in-place upgrade from Dev to Standard.
> Linchi
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
>|||thanks everyone
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OCWCcvXLGHA.3732@.TK2MSFTNGP10.phx.gbl...
> You learn something new every day<g>. Back when 2000 just came out in RTM
> I was told by a MS employee that this was not possible and never had a
> reason to doubt it. I too would like to actually see it done successfully
> but it appears it is possible. Thanks Linchi and sorry Brian.
> --
> Andrew J. Kelly SQL MVP
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
>
Subscribe to:
Posts (Atom)