Instalar SQL Server en local




Hola a todos. En este «experimento», voy a mostrar como se instala SQL Server en local.

Lo primero es lo primero, para poder instalar SQL Server en local, necesitamos 2 programas:

El primero es una BBDD de SQL Server para desarrollar y el segundo es una herramienta gráfica para administrar SQL Server.

1) SQL Server 2008 R2

Seleccionamos SQL Server Configuration Manager.

1

Una vez dentro de SQL Server 2008 R2, tenemos que configurar los protocolos de SQLEXPRESS. Para ello, pulsamos sobre «Protocolos de SQLEXPRESS», seleccionamos «TCP/IP» con el botón derecho y vemos sus propiedades:

QL Server 2008 R2 protocolos sql

 

Tenemos que establecer bien el puerto sobre el que se va a ejecutar.  Para ello, sobre la pestaña de «Direcciones IP», tenemos que ir al último apartado e introducir el puerto 1433 en la fila de nombre «Puerto TCP».

QL Server 2008 R2 SQL propiedades

 

Ahora tenemos que habilitar los servicios propios de SQL Server. Para hacer esto, sobre el menú de la izquierda, seleccionamos «Servicios de SQL Server». En el apartado de «SQL Server (SQLEXPRESS)», mostramos sus propiedades con el botón derecho y accedemos a la pestaña «Servicio». En la fila de «Modo de Inicio», lo dejamos en automático.

QL Server 2008 R2 Servicio

 

Con esto hemos terminado con la primera parte y ya tenemos instalado lo necesario con el programa SQL Server 2008 R2

2) SQL Server Management Studio

Ahora ejecutamos el programa SQL Server Management Studio. Nos aparece una pantalla de autenticación. Seleccionamos la «Autenticación de Windows» y nos conectamos. NOTA: si hemos instalado la versión express, en el login hay que poner «\sqlexpress» seguido de localhost.

SQL Server Management Studio Login

 

Una vez logueado, sobre los «Inicios de sesión», creamos un nuevo usuario:

SQL Server Management Studio Crear usuario

Ya tenemos el usuario creado

SQL Server Management Studio Usuario creado

Sobre el apartado de «Bases de datos», creamos una nueva base de datos.

SQL Server Management Studio Crear BBDD

Ya tenemos la BBDD creada:

SQL Server Management Studio BBDD creada

Ahora solo tenemos que asociar el usuario a la base de datos que antes creamos. Para esto, sobre las propiedades del usuario, en el apartado «General», indicamos sobre «Base de datos predeterminada», la base de datos.

SQL Server Management Studio Asociar usuario

Ahora sobre el apartado de «Asignación de usuarios», asignamos la base de datos que creamos en primera instancia.

SQL Server Management Studio Asociar BBDD

Posibles pasos extras que tendremos que hacer para que funcione:

1) Permitir la autentificación por SQL Server y no solo por autentificación de windows. Para esto, solo tenemos que pulsar botón derecho sobre la conexión y acceder a las propiedades:

SQL Server Acceso1

Y dentro del apartado del apartado seguridad, activamos la autentificación «Modo de autentificación Windows y SQL Server»

SQL Server Acceso2

2) Cuando hagamos cambios, tenemos que reiniciar el servicio, para ello, accedemos a administración del servicio de SQL y reiniciamos el servicio

Reiniciar Servicio SQL

Y con estos pequeños pasos ya tenemos configurado SQL Server para poder desarrollar o lo que haga falta.

Agradecimientos:

 

1.321 comentarios en “Instalar SQL Server en local

  1. Pingback: writeaessay
  2. Pingback: generic levitra
  3. Pingback: cialis walmart
  4. Pingback: tadalafil 20 mg
  5. Pingback: levitra coupon
  6. Pingback: cbd hemp oil
  7. Pingback: viagra pill
  8. Pingback: celebrex problems
  9. Pingback: cap cephalexin
  10. Pingback: blood duloxetine
  11. Pingback: cialis 500mg
  12. Pingback: comprar viagra 100
  13. Pingback: buy cialis
  14. Pingback: Zakhar Berkut hd
  15. Pingback: 4569987
  16. Pingback: buy ebay
  17. Pingback: news news news
  18. Pingback: psy
  19. Pingback: psy2022
  20. Pingback: projectio-freid
  21. Pingback: generic stromectol
  22. Pingback: kinoteatrzarya.ru
  23. Pingback: topvideos
  24. Pingback: video
  25. Pingback: buy insurance
  26. Pingback: buy insurance
  27. Pingback: Ukrainskie-serialy
  28. Pingback: site
  29. Pingback: top
  30. Pingback: tadalafil for sale
  31. Pingback: amazon cialis 20mg
  32. Pingback: viagra for females
  33. Pingback: fildena
  34. Pingback: cialis not working
  35. Pingback: cialis 60mg
  36. Pingback: sildenafil 100 mg
  37. Pingback: cialis europe
  38. Pingback: otc viagra
  39. Pingback: chelovek-iz-90-h
  40. Pingback: ebay viagra pills
  41. Pingback: podolsk-region.ru
  42. Pingback: amlodipine
  43. Pingback: metoprolol tart
  44. Pingback: losartan dose
  45. Pingback: viagra logo
  46. Pingback: cialis 20 mg
  47. Pingback: vardenafil prices
  48. Pingback: cymbalta generics
  49. Pingback: cymbalta reviews
  50. Pingback: mirtazapine 15 mg
  51. Pingback: generic for buspar
  52. Pingback: tizanidine 2 mg
  53. Pingback: wellbutrin generic
  54. Pingback: coreg
  55. Pingback: bender na4alo 2021
  56. Pingback: blogery_i_dorogi
  57. Pingback: cialis pill
  58. Pingback: viagra price
  59. Pingback: uses for cialis
  60. Pingback: levitra from india
  61. Pingback: ketodietione.com
  62. Pingback: Keto diet
  63. Pingback: cephalexin dosage
  64. Pingback: sildenafil citrate
  65. Pingback: cialis 10mg dosage
  66. Pingback: cialis dosage
  67. Pingback: viagra by phone
  68. Pingback: viagra overnight
  69. Pingback: chernaya vodova
  70. Pingback: 66181
  71. Pingback: viagra in canada
  72. Pingback: sildenafil otc
  73. Pingback: cialis peak effect
  74. Pingback: metformin pharmacy
  75. Pingback: Porno
  76. Pingback: vechernyy urgant
  77. Pingback: ukraine
  78. Pingback: lasix 40 mg cost
  79. Pingback: xenical generic
  80. Pingback: clomid dosing
  81. Pingback: A3ixW7AS
  82. Pingback: cialis 5mg dosage
  83. Pingback: cialis price
  84. Pingback: link
  85. Pingback: cialis 800mg black
  86. Pingback: does cialis work
  87. Pingback: cialis coupon
  88. Pingback: sildenafil recall
  89. Pingback: KremlinTeam
  90. Pingback: medunitsa.ru
  91. Pingback: kremlin-team.ru
  92. Pingback: psychophysics.ru
  93. Pingback: yesmail.ru
  94. Pingback: Suicide Squad 2
  95. Pingback: cialis tadalafil
  96. Pingback: psiholog
  97. Pingback: gay chat webcam
  98. Pingback: lexapro and advil
  99. Pingback: viagra 100mg
  100. Pingback: atorvastatin 20 mg
  101. Pingback: sildenafil
  102. Pingback: viagra prices
  103. Pingback: get cialis
  104. Pingback: buy cialis tablets
  105. Pingback: cialis for sale
  106. Pingback: cialis 24 hours
  107. Pingback: cheap viagra
  108. Pingback: Duna 2021
  109. Pingback: cost of viagra
  110. Pingback: 1
  111. Pingback: viagra cheap
  112. Pingback: buy viagra bali
  113. Pingback: natural viagra
  114. Pingback: viagra generic
  115. Pingback: buy prednisone 1mg
  116. Pingback: cheapest viagra
  117. Pingback: low cost viagra
  118. Pingback: stromectol
  119. Pingback: cheap cialis pills
  120. Pingback: ivermectin merck
  121. Pingback: viagra 50 mg cost
  122. Pingback: buy cialis
  123. Pingback: sildenafil 100mg
  124. Pingback: order viagra
  125. Pingback: viagra in india
  126. Pingback: cleantalkorg2.ru
  127. Pingback: levitra vs viagra
  128. Pingback: compra viagra
  129. Pingback: womens viagra
  130. Pingback: order amoxil
  131. Pingback: viagra on line
  132. Pingback: 200 mg lasix
  133. Pingback: drug neurontin
  134. Pingback: viagra pfizer
  135. Pingback: how to get priligy
  136. Pingback: ivermectin drug
  137. Pingback: modafinil paypal
  138. Pingback: ivermectin 50
  139. Pingback: ventolin nebulizer
  140. Pingback: viagra walmart
  141. Pingback: chloroquine uk
  142. Pingback: snorting viagra
  143. Pingback: cialis 2019
  144. Pingback: provigil buy legal
  145. Pingback: viagra tablets
  146. Pingback: zithromax 1000mg
  147. Pingback: ivermectin virus
  148. Pingback: viagra paypal
  149. Pingback: herbal viagra
  150. Pingback: viagra amazon
  151. Pingback: cheap stromectol
  152. Pingback: sildenafil price
  153. Pingback: viagra usa
  154. Pingback: female viagra pill
  155. Pingback: viagra online
  156. Pingback: ivermectin 6mg
  157. Pingback: meritking
  158. Pingback: zithromax pills
  159. Pingback: elexusbet
  160. Pingback: Eurocasino
  161. Pingback: madridbet
  162. Pingback: meritroyalbet
  163. Pingback: eurocasino
  164. Pingback: eurocasino
  165. Pingback: meritking
  166. Pingback: meritroyalbet
  167. Pingback: tadalafil 25mg
  168. Pingback: aabbx.store
  169. Pingback: meritroyalbet
  170. Pingback: viagra uses
  171. Pingback: ne-smotrite-naverx
  172. Pingback: arrogant
  173. Pingback: Dead-Inside
  174. Pingback: low dose cialis
  175. Pingback: sildenafil 500 mg
  176. Pingback: viagra on steroids
  177. Pingback: madridbet
  178. Pingback: uses for cialis
  179. Pingback: trcasino
  180. Pingback: elexusbet
  181. Pingback: ivermectin cream 1
  182. Pingback: stromectol prices
  183. Pingback: cialis pills
  184. Pingback: canada pharmacy
  185. Pingback: viagra for covid
  186. Pingback: viagra precio
  187. Pingback: ivermectin dosage
  188. Pingback: trcasino
  189. Pingback: tombala siteleri
  190. Pingback: tombala siteleri
  191. Pingback: tombala siteleri
  192. Pingback: kory
  193. Pingback: order ivermectin
  194. Pingback: zanaflex pill
  195. Pingback: bimatoprost
  196. Pingback: olumiant fda
  197. Pingback: meritroyalbet
  198. Pingback: molnupiravir order
  199. Pingback: Anónimo
  200. Pingback: Anónimo
  201. Pingback: ivermectin 200 mcg
  202. Pingback: Anónimo
  203. Pingback: ivermectin iv
  204. Pingback: cost of ivermectin
  205. Pingback: ivermectin uk
  206. Pingback: ivermectin kaufen
  207. Pingback: 3rpUI4X
  208. Pingback: ivermectin kaufen
  209. Pingback: uliocx
  210. Pingback: 34tfA26
  211. Pingback: 3J6w3bD
  212. Pingback: 3GrvxDp
  213. Pingback: 3rrZhf7
  214. Pingback: 3L1poB8
  215. Pingback: my-vse-mertvy-2022
  216. Pingback: peptide tadalafil
  217. Pingback: meritroyalbet
  218. Pingback: ivermectin
  219. Pingback: cialis women
  220. Pingback: furosemide online
  221. Pingback: tadalafil cost cvs
  222. Pingback: cialis price
  223. Pingback: baymavi
  224. Pingback: baymavi
  225. Pingback: sildenafil tablets
  226. Pingback: tadalafil cialis
  227. Pingback: tombala siteleri
  228. Pingback: 2carriers
  229. Pingback: 1homeless
  230. Pingback: child porn
  231. Pingback: stromectol uk
  232. Pingback: sildenafil teva
  233. Pingback: que es viagra
  234. Pingback: what is cialis
  235. Pingback: the borgata
  236. Pingback: flccc ivermectin
  237. Pingback: best casino online
  238. Pingback: cialis price
  239. Pingback: hims sildenafil
  240. Pingback: flagyl class
  241. Pingback: keflex names
  242. Pingback: stromectol tablets
  243. Pingback: z.globus-kino.ru
  244. Pingback: buy ivermectin 6mg
  245. Pingback: ivermectin nahdi
  246. Pingback: augmentin esbl
  247. Pingback: meritroyalbet
  248. Pingback: meritking
  249. Pingback: meritking
  250. Pingback: ivermectin 5 mg
  251. Pingback: eurocasino
  252. Pingback: eurocasino
  253. Pingback: stromectol covid
  254. Pingback: yutub
  255. Pingback: madridbet
  256. Pingback: Hosting
  257. Pingback: ivermectina piojos
  258. Pingback: ivermectin 0.1 uk
  259. Pingback: canadianpharmacy
  260. Pingback: ivermectin buy uk
  261. Pingback: meritroyalbet
  262. Pingback: eurocasino
  263. Pingback: ivermectin 2
  264. Pingback: meritroyalbet
  265. Pingback: online pharmacy
  266. Pingback: ivermectin 10 mg
  267. Pingback: child porn
  268. Pingback: fuck google
  269. Pingback: child porn
  270. Pingback: grandpashabet
  271. Pingback: child porn
  272. Pingback: buy cialis pills
  273. Pingback: mazhor4sezon
  274. Pingback: pharmacy
  275. Pingback: filmfilmfilmes
  276. Pingback: gRh9UPV
  277. Pingback: kertyun.flazio.com
  278. Pingback: kerbnt.flazio.com
  279. Pingback: gewrt.usluga.me
  280. Pingback: 9-05-2022
  281. Pingback: buy viagra now
  282. Pingback: TopGun2022
  283. Pingback: Xvideos
  284. Pingback: XVIDEOSCOM Videos
  285. Pingback: ivanesva
  286. Pingback: drugstore online
  287. Pingback: canada drug
  288. Pingback: online pharmacies
  289. Pingback: meritroyalbet
  290. Pingback: Netflix
  291. Pingback: FILM
  292. Pingback: designchita.ru
  293. Pingback: YA-krasneyu
  294. Pingback: design-human.ru
  295. Pingback: designmsu.ru
  296. Pingback: vkl-design.ru
  297. Pingback: irida-design.ru
  298. Pingback: ivermektin
  299. Pingback: psy-
  300. Pingback: psy online
  301. Pingback: Gz92uNNH
  302. Pingback: do-posle-psihologa
  303. Pingback: uels ukrain
  304. Pingback: buy ivermectin nz
  305. Pingback: bahis siteleri
  306. Pingback: DPTPtNqS
  307. Pingback: qQ8KZZE6
  308. Pingback: D6tuzANh
  309. Pingback: SHKALA TONOV
  310. Pingback: canada drugs
  311. Pingback: kwsde.zombeek.cz
  312. Pingback: 3Hk12Bl
  313. Pingback: 3NOZC44
  314. Pingback: 01211
  315. Pingback: tor-lyubov-i-grom
  316. Pingback: film-tor-2022
  317. Pingback: hd-tor-2022
  318. Pingback: hdorg2.ru
  319. Pingback: ivermectin dose
  320. Pingback: JXNhGmmt
  321. Pingback: Psikholog
  322. Pingback: netstate.ru
  323. Pingback: meritroyalbet
  324. Pingback: online pharmacy
  325. Pingback: stromectol 0.1
  326. Pingback: bit.ly
  327. Pingback: meritking
  328. Pingback: lwerfa.iwopop.com
  329. Pingback: kawerf.iwopop.com
  330. Pingback: bucha killings
  331. Pingback: War in Ukraine
  332. Pingback: viagra
  333. Pingback: buy cialis no rx
  334. Pingback: stats
  335. Pingback: revatio
  336. Pingback: Ukraine-war
  337. Pingback: movies
  338. Pingback: gidonline
  339. Pingback: viagra generic
  340. Pingback: web
  341. Pingback: film.8filmov.ru
  342. Pingback: kwerks.iwopop.com
  343. Pingback: Northwest Pharmacy
  344. Pingback: canadian rx
  345. Pingback: kawerc.proweb.cz
  346. Pingback: pedrew.zombeek.cz
  347. Pingback: fermser.flazio.com
  348. Pingback: Anónimo
  349. Pingback: northwestpharmacy
  350. Pingback: canada drugs
  351. Pingback: drugstore online
  352. Pingback: purchase cialis
  353. Pingback: filmgoda.ru
  354. Pingback: rodnoe-kino-ru
  355. Pingback: confeitofilm
  356. Pingback: stat.netstate.ru
  357. Pingback: owzpkg.zombeek.cz
  358. Pingback: sY5am
  359. Pingback: kwenzx.nethouse.ru
  360. Pingback: buy viagra
  361. Pingback: Dom drakona
  362. Pingback: JGXldbkj
  363. Pingback: aOuSjapt
  364. Pingback: ìûøëåíèå
  365. Pingback: psikholog moskva
  366. Pingback: A片
  367. Pingback: porno}
  368. Pingback: Dim Drakona 2022
  369. Pingback: TwnE4zl6
  370. Pingback: psy 3CtwvjS
  371. Pingback: meriking
  372. Pingback: lalochesia
  373. Pingback: buy viagra uk
  374. Pingback: film onlinee
  375. Pingback: drugs for sale
  376. Pingback: canadadrugs
  377. Pingback: stromectol online
  378. Pingback: stromectol usa
  379. Pingback: pharmacy
  380. Pingback: 3qAIwwN
  381. Pingback: video-2
  382. Pingback: sezons.store
  383. Pingback: stromectol buy
  384. Pingback: ivermectina
  385. Pingback: psy-news.ru
  386. Pingback: viagra canada
  387. Pingback: 000-1
  388. Pingback: 3SoTS32
  389. Pingback: 3DGofO7
  390. Pingback: canadianpharmacy
  391. Pingback: canadian drug
  392. Pingback: rftrip.ru
  393. Pingback: madridbet
  394. Pingback: dolpsy.ru
  395. Pingback: logarkomx
  396. Pingback: kin0shki.ru
  397. Pingback: 3o9cpydyue4s8.ru
  398. Pingback: Bahiscom
  399. Pingback: Betmatik
  400. Pingback: Betist
  401. Pingback: Cratosslot
  402. Pingback: Betlike
  403. Pingback: Betebet
  404. Pingback: Mariobet
  405. Pingback: Tempobet
  406. Pingback: Tipobet
  407. Pingback: Klasbahis
  408. Pingback: Vdcasino
  409. Pingback: Casinoeuro
  410. Pingback: imajbet
  411. Pingback: imajbet giris
  412. Pingback: Sahabet
  413. Pingback: mb588.ru
  414. Pingback: 1xbet
  415. Pingback: Bahigo
  416. Pingback: Bahis siteleri
  417. Pingback: Onwin
  418. Pingback: Kralbet
  419. Pingback: Tipobet Giriş
  420. Pingback: Betkolik
  421. Pingback: Casino Siteleri
  422. Pingback: Bettilt
  423. Pingback: Betasus
  424. Pingback: newsukraine.ru
  425. Pingback: Dinamobet
  426. Pingback: Jojobet
  427. Pingback: Jojobet giriş
  428. Pingback: Hepsibahis
  429. Pingback: Marsbahis
  430. Pingback: meritking
  431. Pingback: edu-design.ru
  432. Pingback: tftl.ru
  433. Pingback: buy stromectol
  434. Pingback: brutv
  435. Pingback: stromectol mites
  436. Pingback: stromectol stock
  437. Pingback: site 2023
  438. Pingback: buy propecia cream
  439. Pingback: canadian pharmacys
  440. Pingback: grandpashabet
  441. Pingback: drugs for sale
  442. Pingback: online pharmacies
  443. Pingback: sitestats01
  444. Pingback: 1c789.ru
  445. Pingback: cttdu.ru
  446. Pingback: canadian drugs
  447. Pingback: 1703
  448. Pingback: hdserial2023.ru
  449. Pingback: serialhd2023.ru
  450. Pingback: matchonline2022.ru
  451. Pingback: bit.ly/3OEzOZR
  452. Pingback: bit.ly/3gGFqGq
  453. Pingback: bit.ly/3ARFdXA
  454. Pingback: bit.ly/3ig2UT5
  455. Pingback: bit.ly/3GQNK0J
  456. Pingback: Grandpashabet
  457. Pingback: grandpashabet
  458. Pingback: bep5w0Df
  459. Pingback: www
  460. Pingback: canada drug
  461. Pingback: icf
  462. Pingback: 24hours-news
  463. Pingback: rusnewsweek
  464. Pingback: uluro-ado
  465. Pingback: online pharmacies
  466. Pingback: irannews.ru
  467. Pingback: klondayk2022
  468. Pingback: fildena for lice
  469. Pingback: gravatar.comkqwsh
  470. Pingback: buy viagra 25mg
  471. Pingback: milf porno
  472. Pingback: tqmFEB3B
  473. Pingback: canadian pharmacy
  474. Pingback: madridbet
  475. Pingback: 2022-film
  476. Pingback: meritking
  477. Pingback: meritking
  478. Pingback: fuck google
  479. Pingback: canada viagra
  480. Pingback: sikiş
  481. Pingback: fuvk google
  482. Pingback: okey oyna
  483. Pingback: fuck google
  484. Pingback: fuck google
  485. Pingback: madridbet
  486. Pingback: mangalib
  487. Pingback: buy viagra usa
  488. Pingback: x
  489. Pingback: 9xflix
  490. Pingback: xnxx
  491. Pingback: 123movies
  492. Pingback: canada drugs
  493. Pingback: xxx
  494. Pingback: drugs for sale
  495. Pingback: viagra canada
  496. Pingback: madridbet
  497. Pingback: kinokrad
  498. Pingback: batmanapollo
  499. Pingback: canada pharmacies
  500. Pingback: cialis from canada
  501. Pingback: buy viagra now
  502. Pingback: kamagra gel online
  503. Pingback: canada pharmacies
  504. Pingback: ギャンブル
  505. Pingback: buy viagra 25mg
  506. Pingback: canada medication
  507. Pingback: vsovezdeisrazu
  508. Pingback: 2023
  509. Pingback: Homepage
  510. Pingback: child porn
  511. Pingback: levitra
  512. Pingback: meritking
  513. Pingback: child porn
  514. Pingback: black viagra pill
  515. Pingback: madridbet
  516. Pingback: ipsychologos

Los comentarios están cerrados.