Get SQL Server database server address -


i installing app , @ point supposed provide server details. installed sql server express , installed sql server management studio.

this screenshot:

enter image description here

i did execute command

select @@servername

but got response:

enter image description here

i running on local machine. how can find database server address , server password?.

ps: not remember setting password when installing sql server.

thanks.

when executed command select @@servername, how connected server? running command required knowing servername , authentication of kind. i'm guessing connected desktop-kojlcif\sqlexpress or .\sqlexpress using windows authentication.

when installed sql express, there option windows authentication or sql server + windows (aka mixed mode) authentication. if chose windows authentication (which default if recall), not have sql server usernames or passwords.

the app installing appears required sql auth, need pick mixed mode in setup (which allows both windows auth , sql auth). can find setting in recent versions of sql server management studio right-clicking database server in object explorer, going properties, , looking @ security page. older versions of sql require going tool included in installation folders-- server configuration or such, name escapes me. change authentication "sql server , windows authentication mode". believe sql server restart required after doing this.

you can create sql logins username , passwords , appropriate permissions using gui in ssms (expand security folder under server , @ logins sub folder) or via create login t-sql command.

there fixed sql login called 'sa' exist if sql auth enabled. right click login, go properties, , change password. careful giving out sa credentials app, can control entire server.


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more