Back devices: machine

Showing posts with label machine. Show all posts

Friday, March 30, 2012

How can i restrict the SA user

hi,
Is there any way to restrict the SA access. The problem is that all my
client machine users knows the sa password, and also right now i don't want
to change the password. So i just want to know is there any way to restrict
their access ? thanking in advance
ARHi
SA is not restrictable as it is the highest built in security account.
If security is so important, you have to change the password. Remember, if
you are using integrated security, domain and local admins are by default,
mapped to SA.
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/
"Aneesh" <aneesh.r@.eostek.com> wrote in message
news:u4iPss30EHA.2608@.TK2MSFTNGP10.phx.gbl...
> hi,
> Is there any way to restrict the SA access. The problem is that all my
> client machine users knows the sa password, and also right now i don't
want
> to change the password. So i just want to know is there any way to
restrict
> their access ? thanking in advance
> AR
>|||"Aneesh" <aneesh.r@.eostek.com> wrote in message
news:u4iPss30EHA.2608@.TK2MSFTNGP10.phx.gbl...
> hi,
> Is there any way to restrict the SA access. The problem is that all my
> client machine users knows the sa password, and also right now i don't
want
> to change the password. So i just want to know is there any way to
restrict
> their access ? thanking in advance
> AR
Make a new user and give him an appropriate permissions.
regards,
Dra

Wednesday, March 21, 2012

How can I move/import .MDF file to another machine ?

Our SQL Server machine just crashed, but I can get to the .MDF file (not a
backup file). If I have the .MDF file of a SQL Server database, can I import
this file to another SQL Server and look at it at the new machine ?
Thanks.If the SQL Server crashed in a weird state, you MIGHT be able to recover the
file.
Copy the MDF and LDF files to the other machine, and try attaching them.
(Look at sp_attach_db in Books Online).
If that fails, you can try just the MDF file, using sp_attach_single_file_db
(also documented in books online).
If that also fails, then you might have just learned the value of backups.
Better late than never. :-)
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> Our SQL Server machine just crashed, but I can get to the .MDF file (not a
> backup file). If I have the .MDF file of a SQL Server database, can I
import
> this file to another SQL Server and look at it at the new machine ?
> Thanks.|||Thank you.
I do not have the LDF file, and when I tried sp_attach_single_file_db
I got an error saying something like the MDF file does not have the right
format, or something like that.
I already recommend them to backup next time.
Thank you for your help.
"Aaron [SQL Server MVP]" wrote:
> If the SQL Server crashed in a weird state, you MIGHT be able to recover the
> file.
> Copy the MDF and LDF files to the other machine, and try attaching them.
> (Look at sp_attach_db in Books Online).
> If that fails, you can try just the MDF file, using sp_attach_single_file_db
> (also documented in books online).
> If that also fails, then you might have just learned the value of backups.
> Better late than never. :-)
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
> news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> > Our SQL Server machine just crashed, but I can get to the .MDF file (not a
> > backup file). If I have the .MDF file of a SQL Server database, can I
> import
> > this file to another SQL Server and look at it at the new machine ?
> > Thanks.
>
>|||See if this helps:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
This is why Backups are so important.
--
Andrew J. Kelly SQL MVP
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:7E0625EA-A06C-49B4-833A-232C4B11DAC5@.microsoft.com...
> Thank you.
> I do not have the LDF file, and when I tried sp_attach_single_file_db
> I got an error saying something like the MDF file does not have the right
> format, or something like that.
> I already recommend them to backup next time.
> Thank you for your help.
> "Aaron [SQL Server MVP]" wrote:
>> If the SQL Server crashed in a weird state, you MIGHT be able to recover
>> the
>> file.
>> Copy the MDF and LDF files to the other machine, and try attaching them.
>> (Look at sp_attach_db in Books Online).
>> If that fails, you can try just the MDF file, using
>> sp_attach_single_file_db
>> (also documented in books online).
>> If that also fails, then you might have just learned the value of
>> backups.
>> Better late than never. :-)
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
>> news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
>> > Our SQL Server machine just crashed, but I can get to the .MDF file
>> > (not a
>> > backup file). If I have the .MDF file of a SQL Server database, can I
>> import
>> > this file to another SQL Server and look at it at the new machine ?
>> > Thanks.
>>

How can i merge ASPNEDB.mdb with my Database

can anyone explain me in detail abt web.cofig and machine.config with an easy and suitable example , also i wana know that as u know that asp.net 2.0 provides a builtin ASPNETDB but it contain limited and general entities for any real time application i have other entites for that i have to make another Database so i hav 2 databases for any application but i want to use only 1 DB ,my question is i want to merge aspnetdb.mdb with my new database do u know how can i merge it ?? but the functionality of ASPNETDB.mdb remain same

If your new database is SQL Server, then you can simply run the ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe) on your new database.

http://msdn2.microsoft.com/en-us/library/ms229862(VS.80).aspx

how can I manage MSDE with SQL?

please I need some help about how can I get MSDE for VB6 and I want to know how to manage this on th Customer machineWhat do you mean by manage?|||Download MSDE from here:

http://www.microsoft.com/sql/msde/downloads/download.asp

Here is a web based administrative tool:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

If you want a Windows based administrative tool, you can use the SQL Server 2005 Express Manager to manage MSDE:

http://www.microsoft.com/downloads/details.aspx?familyid=C7A5CC62-EC54-4299-85FC-BA05C181ED55&displaylang=en

Before you can install the Express Manager, you must install SQL Server 2005 Express:

http://www.microsoft.com/downloads/details.aspx?familyid=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en
sql

Monday, March 12, 2012

How can I install SS2K with domain account?

Hi all,
I have seen in documents that I can install SS2K on a machine without network domain connection using a domain account.It said that domain accounts are prefered according to some reasons and it is not limited to machines on a domain so you should do it on a single PC.
I tried this during installation and entered many different things but no chance:
<OS_account>
<machine_name>/<OS_account>
...
Would you please telling me what should I enter as service starter account if I want to use domain users?
-Thanks in advanceIn order to "use domain users" and thus windows-based authentication for domain accounts you need to make sure that the server where you install SS2K is part of the domain (same or belongs to the trusted domain both ways, or belongs to a sub-domain). You also need to have a domain account that has admin permissions on the server. That's the account you'll run the service under. If you use services applet to make an account assignment, make sure to go to local security afterwards and add this account to "Lock pages in memory".

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!

All VS2005 pro comes with free SQL Server 2005 developer edition so you can install one in each Vista and do the needed configuration of enabling browser service, and enabling both TCP/IP and Named Pipes in configuration Manager and use the Surface Area Configuration tool to allow both local and remote and allow TCP/IP and Named Pipes. While you are at it also configure mixed Authentication so all developer can register each other SQL Server and access all in one place.

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

Thanks for the reply. My question probably not clear for what we're trying to do. Actually, we are trying to install an instance of SQL Server 2005 Developer Edition (whcih come with Visual Studio Developer Edition into a machine running Windows 2000 SP4). And then I installed the Visual Studio 2005 professional edition into my company which is running on a Vista version Ultimate. Both installation success without any big problem. However, I would like to be able to manage that SQL Server 2005 Developer edition which installed in that Windows 2000 server through my local computer (Windows Vista with Visual Studio 2005 Prof installed). The problem is, there is a SQL Server 2005 Express edition installed into my computer (Vista) when I installed teh Visual Studio. And now, I tried to install the Sql Server Mangement Studio from SQL SErver 2005 Developer edition into my Vista machine, the system doesnt allow me to do it. So, do i have to uninstall the express edition in my local computer (vista) and then install the SSMS from the SQL Server 2005 Developer edition disc? Or, there's somoe other work around that it will allow me to install the SSMS from SQL Server 2005 Developer edition and the same time, keep the 2005 Express edition running in my local computer system. My reason is, the SSMS is just a management tools, it shouldnt depends on what version of DB engine installed into my local computer. Anyone please help

|||

I am one of the people who got the SQL Server developer edition price down from $450 to $50 list so I don't think such strange uses is valid. However you can uninstall the standard Express and use the Advanced which is also free and comes with most features of the full product including Management Studio. But you still have to do what I have explained in my first post because Express and the Developer edition comes with most services disabled.

|||

ic.. so uninstall the pre-installed sql server express from my computer (which has the visual studio 2005 prof edition installed) wont affect my visual studio 2005, right? Just want to make sure before i uninstall anything Smile sorry about the noob question..

|||

Actually Microsoft now let you download the Management Studio for standard Express so download it below and install it. This link also gives you features compare of the Advanced and the Standard Express. But remember you have to go back and use my remote connection instruction. Hope this helps.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

Another option is to uninstall Express and use Express Advanced that comes with Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en

|||

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

Friday, March 9, 2012

how can I insert a semicolon as user data?

I'm working with an existing program that crafts an insert statementfrom user input. The data is machine generated, though, and someof it has semicolons. How can I "escape" those semicolons so thatI can insert them into the database? Does the ESCAPE key workwith the insert statement, too? Can I just replace the ";" withsome other character(s) to escape it? I'm not finding much in theonline help. Thanks!
If by "craft" you mean concatenating strings to create a SQL statement...you should not do that.
If you build a parameterized sql statement, then the semi-colons would not be an issue.|||ie, you mean use a stored procedure, right? yes, they're usingjust a "crafted sql statement right now - "insert into blah blah blah"and then filling in the parameters. its a console app inc#. I was going to try and just do a replace on the insertstatement, but now i think i might just go and redo the whole thing asa stored procedure. but if I were going to replace the ";" withinan insert statement, how would that work, or can't it be done?
|||Can you post how your INSERT statement looks like. This will give a better idea what you are planning to do!
|||If the semi-colon is properly quoted, it should be ok. It's usually the quotes that get you when you concatenate.
As far as creating a stored-proc goes, you can execute parameterized sql statements without taking it all the way to a stored-proc.
for example:
"UPDATE someTable SET someField=@.p1"
Then when you create the command object, you simple need to add a parameter named @.p1 and give it a value.
Since @.p1 is a parameter, even if its string data, it does not need to be quoted.
With parameterized sql, you get the benefit of ad-hoc queries with the safety (from sql injection) of a stored proc.
Also, when parameterized sql statements are sent to sql server, the execution plan can be cached improving performance.
For example: "SELECT someFields FROM someTable WHERE someId=@.p1"
In the previous statement, the same execution plan would be reused if you needed to issue that query multiple times for multiple values of someId.
This - on the other hand: "SELECT someFields FROM someTable WHERE someId=5"
would only get reused if you keep querying for someId=5

Note: The Microsoft DAAB (Data Access Application Block) can be especially usefull for issuing queries.
|||Actually, a parameterized statement was what was being done originally,so I'm not sure now. I changed things to an actual storedprocedure, but the original problem is still occurring, so maybe itsnot the semicolon after all. The error I'm getting is
"System.IndexOutOfRangeException: Index was outside the bounds of the array.
at SmatFileReader.SmatReader.Main(String[] args)"
I'm not fully sure what that means. I'm trying to debug it now...any ideas?

Monday, February 27, 2012

How can I get the username from an application?

Hi everybody,

Here the environment is application in 3 layers.
So the user in his client machine, access the application in an application server that sends the request to my sql server database server.
My problem is: when I run sp_who from Query Analyzer, I see the host name that is pre-defined inside code application. But, actually, I need to know the user who is requesting the transactio so I can know right the person who is slowing my database performance...
Do you know, any function, procedure or anything else that I can use in the application code in order to provide the user or the host name from the client machine???
I hope some answers...

Thank you all,Look up NILADIC functions in Books Online.|||host_name()|||Hi all,

I have this doubt: may I apply SP3a in my SQL Server production database while it is operational?
I mean, may I do this version upgrade while the databases are online and users continue accessing the databases normally?
My actual version is 8.00.194 (no SP applied), and I am planning to apply SP3a.

Thank you in advance,|||No, when applying sp3a to a server that is currently at RTM (what you load from the CD) will require a reboot of Windows. There will be a brief service interruption while the machine reboots.

-PatP|||host_name()Will host_name() help in a three tier environment? I would expect it to return the name of the middleware server.

-PatP|||So this function host_name() doesn't help me, because I need to see the client host name during sp_who...
Does someone can explain a solution for this?

Thanks,|||The easiest way is to have your middleware set the hostname (http://support.microsoft.com/default.aspx?scid=kb;en-us;140301) equal to however it identifies the caller (user name, account number, etc). There are other ways to do this, but they get ugly very quickly and each solution is VERY specific to the installation/application involved.

-PatP

Friday, March 30, 2012

How can i restrict the SA user

Wednesday, March 21, 2012

How can I move/import .MDF file to another machine ?

How can I move/import .MDF file to another machine ?

How can I move/import .MDF file to another machine ?

How can i merge ASPNEDB.mdb with my Database

how can I manage MSDE with SQL?

Monday, March 12, 2012

How can I install SS2K with domain account?

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

How can I install SQL Server 2005 Developer Edition''s Management Studio on a desktop machine?

Friday, March 9, 2012

how can I insert a semicolon as user data?

Monday, February 27, 2012

How can I get the username from an application?

Back devices

Blog Archive

About Me